8.24. GRANT ROLES

Synopsis

GRANT role [, ...]
TO ( user | USER user | ROLE role) [, ...]
[ GRANTED BY ( user | USER user | ROLE role | CURRENT_USER | CURRENT_ROLE ) ]
[ WITH ADMIN OPTION ]

Description

Grants the specified role(s) to the specified principal(s) in the current catalog.

If the WITH ADMIN OPTION clause is specified, the role(s) are grantedto the users with GRANT option.

For the GRANT statement for roles to succeed, the user executing it either shouldbe the role admin or should possess the GRANT option for the given role.

The optional GRANTED BY clause causes the role(s) to be granted withthe specified principal as a grantor. If the GRANTED BY clause is notspecified, the roles are granted with the current user as a grantor.

Examples

Grant role bar to user foo

GRANT bar TO USER foo;

Grant roles bar and foo to user baz and role qux with admin option

GRANT bar, foo TO USER baz, ROLE qux WITH ADMIN OPTION;

Limitations

Some connectors do not support role management.See connector documentation for more details.

See Also

CREATE ROLE, DROP ROLE, SET ROLE, REVOKE ROLES