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, 2506🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema in Oracle? For a us...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...