SHOW ROLES

On this page Carat arrow pointing down
Warning:
As of October 4, 2019, CockroachDB v2.0 is no longer supported. 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