GRANT (Role)
Assigns roles to users or other roles.
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 OPTIO
N.
Examples
See Granting Database Roles in the Administrator's Guide.