GRANT ROLE

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

GRANT data_scientist TO joe;

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

• mz_internal.mz_show_role_members
• mz_internal.mz_show_my_role_members

Related pages

• SHOW ROLE MEMBERSHIP
• CREATE ROLE
• ALTER ROLE
• DROP ROLE
• DROP USER
• REVOKE ROLE
• ALTER OWNER
• GRANT PRIVILEGE
• REVOKE PRIVILEGE