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
| Field | Use |
|---|---|
| role_name | The role name to add member_name as a member. |
| member_name | The role name to add to role_name as a member. |
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.