On this page 
The SHOW ROLES statement lists the roles for all databases.
Synopsis
Required privileges
The user must have the SELECT privilege on the system table.
Example
> SHOW ROLES;
+-----------+
| role_name |
+-----------+
| admin |
| dev_ops |
+-----------+
See also
- Authorization
CREATE ROLE(Enterprise)DROP ROLE(Enterprise)GRANT <privileges>REVOKE <privilegesGRANT <roles>REVOKE <roles>- Manage Users
Was this helpful?
