# GRANT ROLE
`GRANT` grants membership of one role to another role.

> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


`GRANT` grants membership of one role to another role. Roles can be members of
other roles, as well as inherit all the privileges of those roles.

## Syntax



```mzsql
GRANT <role_name> [, ...] TO <grantee> [, ...]

```

| Syntax element | Description |
| --- | --- |
| `<role_name>` | The name of the role being granted.  |
| `<grantee>` | The name of the receiving role; i.e., the grantee.  |


## Examples

```mzsql
GRANT data_scientist TO joe;
```

```mzsql
GRANT data_scientist TO joe, mike;
```

## Privileges

The privileges required to execute this statement are:

- `CREATEROLE` privileges on the system.

## Useful views

- [`mz_internal.mz_show_role_members`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/system-catalog/mz_internal/index.md#mz_show_role_members)
- [`mz_internal.mz_show_my_role_members`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/system-catalog/mz_internal/index.md#mz_show_my_role_members)

## Related pages

- [`SHOW ROLE MEMBERSHIP`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-role-membership/index.md)
- [`CREATE ROLE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/create-role/index.md)
- [`ALTER ROLE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/alter-role/index.md)
- [`DROP ROLE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-role/index.md)
- [`DROP USER`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/drop-user/index.md)
- [`REVOKE ROLE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/revoke-role/index.md)
- [`ALTER OWNER`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/index.md#rbac)
- [`GRANT PRIVILEGE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/grant-privilege/index.md)
- [`REVOKE PRIVILEGE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/revoke-privilege/index.md)