Back to Materialize

GRANT ROLE

doc/user/content/sql/grant-role.md

1231.0 KB
Original Source

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

{{% include-syntax file="examples/grant_role" example="syntax" %}}

Examples

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

Privileges

The privileges required to execute this statement are:

{{% include-headless "/headless/sql-command-privileges/grant-role" %}}

Useful views