Note:
Cockroach Labs supports the current stable release and two releases prior. Therefore, this version will no longer be supported after the Fall 2019 release.

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

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

See Also



Yes No