SHOW ROLES

On this page

New in v2.0: 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;

+----------+
| rolename |
+----------+
| admin    |
| dev_ops  |
+----------+

See Also

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

Was this helpful?