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
GRANT <role_name> [, ...] TO <grantee> [, ...]
| Syntax element | Description |
|---|---|
<role_name>
|
The name of the role being granted. |
<grantee>
|
The name of the receiving role; i.e., the grantee. |
Examples
GRANT data_scientist TO joe;
GRANT data_scientist TO joe, mike;
Privileges
The privileges required to execute this statement are:
CREATEROLEprivileges on the system.