> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing the role grants for users and roles.

# system.role_grants

<h2 id="description">
  Description
</h2>

Contains the role grants for users and roles. To add entries to this table, use `GRANT role TO user`.

<h2 id="columns">
  Columns
</h2>

* `user_name` ([Nullable(String)](/reference/data-types/index)) — User name.
* `role_name` ([Nullable(String)](/reference/data-types/index)) — Role name.
* `granted_role_name` ([String](/reference/data-types/index)) — Name of role granted to the `role_name` role. To grant one role to another one use `GRANT role1 TO role2`.
* `granted_role_id` ([UUID](/reference/data-types/index)) — The ID of the role.
* `granted_role_is_default` ([UInt8](/reference/data-types/index)) — Flag that shows whether `granted_role` is a default role. Possible values: • 1 — `granted_role` is a default role, • 0 — `granted_role` is not a default role.
* `with_admin_option` ([UInt8](/reference/data-types/index)) — Flag that shows whether `granted_role` is a role with `ADMIN OPTION` privilege. Possible values: • 1 — The role has `ADMIN OPTION` privilege.• 0 — The role without `ADMIN OPTION` privilege.