mysql.role_edges

Purpose

The mysql.role_edges view displays the relationships between roles and users who are granted the roles.

Columns

Sample query

Query the relationship between the role1 role and the user001 user.

1. Create a role named role1.

   obclient [oceanbase]> CREATE ROLE IF NOT EXISTS role1;
   Query OK, 0 rows affected, 1 warning
   

2. Grant the ALTER SYSTEM privilege to role1.

   obclient [oceanbase]> GRANT ALTER SYSTEM ON *.* TO role1;
   

3. Create a user named user001.

   obclient [oceanbase]> CREATE USER 'user001'@'%' IDENTIFIED BY '******';
   

4. Grant role1 to user001.

   obclient [oceanbase]>GRANT role001 TO user001 WITH ADMIN OPTION;;
   

5. Query the relationship between role1 and user001.

   obclient > SELECT * FROM mysql.role_edges;
   

   The query result is as follows:

   +-----------+-----------+---------+---------+-------------------+
   | FROM_HOST | FROM_USER | TO_HOST | TO_USER | WITH_ADMIN_OPTION |
   +-----------+-----------+---------+---------+-------------------+
   | %         | role001   | %       | user001 | Y                 |
   +-----------+-----------+---------+---------+-------------------+
   1 row in set (0.001 sec)
   

References

mysql.default_roles