GRANT ROLE

Grant a role to a user or a role.

Syntax

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

Parameters

{{< sql-section file="data/sql/roles.json" data="grantingRoleParameters" >}}

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