SHOW ROLES

On this page Carat arrow pointing down

New in v2.0: The SHOW ROLES statement lists the roles for all databases.

Synopsis

SHOW ROLES

Required Privileges

The user must have the SELECT privilege on the system table.

Example

icon/buttons/copy
> SHOW ROLES;
+----------+
| rolename |
+----------+
| admin    |
| dev_ops  |
+----------+

See Also


Yes No
On this page

Yes No