SHOW ROLES

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 <privileges
• GRANT <roles>
• REVOKE <roles>
• Manage Users

Was this helpful?

Please tell us more.') $('#feedback-prompt-toc').hide() }); });