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

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

Was this helpful?