GRANT (Role Form) Statement| SQL Data Control Language | Teradata Vantage - GRANT (Role Form) - Analytics Database - Teradata Vantage

SQL Data Control Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantage™

Grants roles to users or other roles.

You cannot grant external roles with this GRANT statement. You can only grant individual privileges and database roles to external roles within Vantage.

For more information, see Teradata Vantage™ - Analytics Database Security Administration, B035-1100 and Teradata Vantage™ - Database Administration, B035-1093.

ANSI Compliance

This statement is ANSI SQL:2011 compliant.

Required Privileges

To grant a role, you must have the WITH ADMIN OPTION privilege on the role. 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.

A grantor does not need to have any privilege, including WITH ADMIN OPTION, on the grantee to grant a privilege to it, whether the grantee is a role or a user.