GRANT ROLE
View as MarkdownGRANT 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.