On this page 
Warning:
GA releases for CockroachDB v23.1 are no longer supported. Cockroach Labs will stop providing LTS Assistance Support for v23.1 LTS releases on November 13, 2025. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, refer to the Release Support Policy.
The SHOW SYSTEM GRANTS statement lists the system privileges granted to users.
Syntax
Use the following syntax to show the system privileges granted to users:
SHOW SYSTEM GRANTS [FOR <users...>]
Parameters
| Parameter | Description |
|---|---|
users |
The user, or comma-separated list of users, whose system privileges you want to show. |
Response
Privilege grants
The SHOW SYSTEM GRANTS statement returns the following fields:
| Field | Description |
|---|---|
grantee |
The name of the user. |
privilege_type |
The name of the system privilege granted to the user. |
is_grantable |
t (true) if the user has the grant option on the object; f (false) if not. |
Required privileges
- No privileges are required to use
SHOW SYSTEM GRANTS.
Examples
Show all system grants
To list all system grants for all users and roles:
> SHOW SYSTEM GRANTS;
grantee | privilege_type | is_grantable
----------+----------------------+---------------
max | VIEWACTIVITY | t
max | VIEWCLUSTERMETADATA | t
max | VIEWDEBUG | t
alice | VIEWACTIVITYREDACTED | f
alice | NOSQLLOGIN | f
(5 rows)
Show a specific user or role's grants
To list all system grants for a specific user or role:
> CREATE USER max;
> GRANT SYSTEM ALL TO max WITH GRANT OPTION;
> SHOW SYSTEM GRANTS FOR max;
grantee | privilege_type | is_grantable
----------+----------------+---------------
max | ALL | t
(1 row)
See also
Was this helpful?
