mysql.role_edges

Purpose

The mysql.role_edges view displays the grant relationships between roles and users.

Columns

Sample query

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

1. Create the role1 role.

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

2. Grant the ALTER SYSTEM privilege to the role1 role.

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

3. Create the user001 user.

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

4. Grant the role1 role to the newly created user001 user.

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

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

   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

• For information about the default roles enabled for a user, see mysql.default_roles.

• For more information about the operations and descriptions of user roles, see View roles.