> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW SYSTEM GRANTS

The `SHOW SYSTEM GRANTS` [statement](https://docs.cockroachlabs.com/docs/stable/sql-statements.md) lists the [system privileges](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#supported-privileges) [granted](https://docs.cockroachlabs.com/docs/stable/grant.md) to [users](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#sql-users).

## Syntax

Use the following syntax to show the [system privileges](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#supported-privileges) granted to users:

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

## Parameters

| Parameter | Description |
| - | - |
| `users` | The [user](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#sql-users), 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](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#supported-privileges) 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](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#supported-privileges) are required to use `SHOW SYSTEM GRANTS`.

## Examples

### Show all system grants

To list all system grants for all users and roles:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> 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:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> CREATE USER max;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> GRANT SYSTEM ALL TO max WITH GRANT OPTION;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW SYSTEM GRANTS FOR max;
```

```
  grantee | privilege_type | is_grantable
----------+----------------+---------------
  max     | ALL            |      t
(1 row)
```

## See also

* [Authorization](https://docs.cockroachlabs.com/docs/stable/authorization.md)
* [System Privileges](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#supported-privileges)
* [`GRANT`](https://docs.cockroachlabs.com/docs/stable/grant)
* [`REVOKE`](https://docs.cockroachlabs.com/docs/stable/revoke)
* [Manage Users](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#create-and-manage-users)
* [Information Schema](https://docs.cockroachlabs.com/docs/stable/information-schema.md)