GRANT ROLE

Grant a role to a user or a role.

Syntax

GRANT ROLE <role_name>
TO { ROLE | USER } <role_or_user_name>

Parameters

<role_name> String

Indicates the name of the role you are assigning.

---

<role_or_user_name> String

Indicates the role or user that you are granting the role to.

Examples

Grant role to a user

GRANT ROLE role1
TO USER "user@dremio.com"

Grant role to a role

GRANT ROLE subrole
TO ROLE role1