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

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

See also



Yes No