# REVOKE ROLE
`REVOKE` revokes membership of one role from another role.

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


`REVOKE` revokes membership of a role from the target role.

## Syntax

```mzsql
REVOKE <role_to_remove> [, ...] FROM <target_role> [, ...];
```

Syntax element       | Description
---------------------|------------------
`<role_to_remove>`   | The name of the role to remove from the `<target_role>`.
`<target_role>`      | The name of the role from which the to remove the `<role_to_remove>`.


## Examples

```mzsql
REVOKE data_scientist FROM joe;
```

```mzsql
REVOKE data_scientist FROM joe, mike;
```

## Privileges

The privileges required to execute this statement are:

- `CREATEROLE` privileges on the systems.

## 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)
- [`GRANT ROLE`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/grant-role/index.md)
- [`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)