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

GRANT role_name TO GROUP member_name ,
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;
Back to top ↑