GRANT ROLE
GRANT grants membership of one role to another role. Roles can be members of
other roles, as well as inherit all the attributes and privileges of those roles.
WARNING! Currently, roles have limited functionality in Materialize. This is part of the
work to enable Role-based access control (RBAC) in a future release (#11579).
Syntax
| Field | Use |
|---|---|
| role_name | The role name to add member_name as a member. |
| member_name | The role name to add to role_name as a member. |
Examples
GRANT data_scientist TO joe;
GRANT data_scientist TO joe, mike;