On this page
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
Required Privileges
The user must have the SELECT
privilege on the system table.
Example
> SHOW ROLES;
+----------+
| rolename |
+----------+
| admin |
| dev_ops |
+----------+