On this page

    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