SHOW ROLES

On this page Carat arrow pointing down
Warning:
CockroachDB v2.0 is no longer supported as of October 4, 2019. For more details, refer to the Release Support Policy.

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