GRANT (Role)

Assigns roles to users or other roles.

Granting a role does not activate the role automatically; you must enable it with SET ROLE command.

Syntax

GRANT role[,…] TO grantee[,…] [ WITH ADMIN OPTION ]

Parameters

role

A role to grant
grantee

Designates users to be granted the specified roles, one of the following:
WITH ADMIN OPTION

Gives grantee the privilege to grant the same role to other users or roles. For details, see Granting Privileges .

Privileges

Non-superuser: Role grantee given WITH ADMIN OPTION.

Examples

See Granting Database Roles in the Administrator's Guide.

See Also

REVOKE (Role)