Collections:
ROLES_GRAPHML() - User Role Graph in GraphML Format
How to obtain User Role Graph in GraphML Format using the ROLES_GRAPHML() function?
✍: FYIcenter.com
ROLES_GRAPHML() is a MySQL built-in function that
returns user role graph in GraphML format.
For example:
SELECT ROLES_GRAPHML();
-- +--------------------------------------------------------------------+
-- | ROLES_GRAPHML() |
-- +--------------------------------------------------------------------+
-- | <?xml version="1.0" encoding="UTF-8"?>
<graphml xmlns="http://graphml.graphdrawing.org/xmlns"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://graphml.graphdrawing.org/xmlns
http://graphml.graphdrawing.org/xmlns/1.0/graphml.xsd">
<key id="key0" for="edge" attr.name="color" attr.type="int" />
<key id="key1" for="node" attr.name="name" attr.type="string" />
<graph id="G" edgedefault="directed" parse.nodeids="canonical"
parse.edgeids="canonical" parse.order="nodesfirst">
<node id="n1">
<data key="key1">`mysql.infoschema`@`localhost`</data>
</node>
<node id="n2">
<data key="key1">`mysql.session`@`localhost`</data>
</node>
<node id="n3">
<data key="key1">`mysql.sys`@`localhost`</data>
</node>
<node id="n4">
<data key="key1">`root`@`localhost`</data>
</node>
<node id="n5">
<data key="key1">`fyi`@`localhost`</data>
</node>
<node id="n16">
<data key="key1">`fyi`@`%`</data>
</node>
</graph>
</graphml>
-- +--------------------------------------------------------------------+
Reference information of the ROLES_GRAPHML() function:
ROLES_GRAPHML(): xml Returns user role graph in GraphML format. Arguments, return value and availability: xml: Return value. user role graph in GraphML format. Available since MySQL 4.0.
⇒ ROW_COUNT() - Affected Rows from Last DML Statement
⇐ PS_THREAD_ID() - PS Thread ID of Given Connect
2025-02-16, 2044🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...