ROLES_GRAPHML() - User Role Graph in GraphML Format

Q

How to obtain User Role Graph in GraphML Format using the ROLES_GRAPHML() function?

✍: FYIcenter.com

A

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

MySQL Functions on System Information

⇑⇑ MySQL Function References

2023-12-19, 198🔥, 0💬