GRANT ROLE

Grant role to user

GRANT ROLE role_name[, role_name...] TO USER user_email;

Description

Grants access to Role(s) to a User. This allows the User to USE ROLE and inherit all the privileges granted to the Role.

The current role requires one of the following privileges:

• Ownership of Organization

• MANAGE_MEMBERS privilege on Organization

Arguments

role_name[, role_name...]

One or more Roles to grant to the User.

user_email

Email of the User

Example

<no-db>/<no-store># GRANT ROLE sysadmin TO USER '[e-mail]';

Grant role to other role

GRANT ROLE role_name[, role_name...] TO ROLE role_name[, role_name...] [WITH GRANT OPTION];

Description

Grants access to Role(s) to other Role(s). This sets up a role-inheritance allowing parent roles to inherit privileges from child Roles.

The current role requires one of the following privileges:

• Ownership of Organization

• MANAGE_MEMBERS privilege on Organization

• OWNER privilege on both parent and child roles.

Example

<no-db>/<no-store># GRANT ROLE role1 TO ROLE sysadmin;