On this page 
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
Required Privileges
The user must have the SELECT privilege on the system table.
Example
> SHOW ROLES;
+----------+
| rolename |
+----------+
| admin |
| dev_ops |
+----------+
See Also
CREATE ROLE(Enterprise)DROP ROLE(Enterprise)GRANT <privileges>REVOKE <privilegesGRANT <roles>(Enterprise)REVOKE <roles(Enterprise)- Manage Roles
- Manage Users
Was this helpful?
