Grants roles to users or other roles.
The following users can grant a role to a user or other role:
- User DBC.
- A user who has been granted the specified role WITH ADMIN OPTION.
The creator of a role is automatically granted the specified role WITH ADMIN OPTION.
- A user who has an active role to which the specified role was granted WITH ADMIN OPTION. An active role can be a current role or a nested role of a current role.
You cannot grant external roles with this GRANT statement. You can only grant individual privileges and database roles to external roles within Vantage.
ANSI Compliance
This statement is ANSI SQL:2011 compliant.
Required Privileges
- WITH ADMIN OPTION on the role
A grantor needs no privilege on the grantee to grant a privilege to it, whether the grantee is a role or a user.