SHOW ROLES

The SHOW ROLES statement lists the roles for all databases.

Synopsis

Required privileges

The user must have the SELECTprivilege on the system table.

Example

> SHOW ROLES;

+-----------+
| role_name |
+-----------+
| admin     |
| dev_ops   |
+-----------+

See also

• Authorization
• CREATE ROLE (Enterprise)
• DROP ROLE (Enterprise)
• GRANT <privileges>
• REVOKE <privileges
• GRANT <roles> (Enterprise)
• REVOKE <roles (Enterprise)
• Manage Users

Was this page helpful?
YesNo