SHOW SYSTEM GRANTS

The SHOW SYSTEM GRANTS lists the to .

Syntax

Use the following syntax to show the granted to users:

SHOW SYSTEM GRANTS [FOR <users...>]

Parameters

Parameter	Description
users	The , 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 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 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