Roles/External Roles | Privileges for Database Administration | Teradata Vantage - Roles and External Roles - Advanced SQL Engine - Teradata Database

SQL Data Control Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
sqd1591723147563.ditamap
dita:ditavalPath
sqd1591723147563.ditaval
dita:id
B035-1149
lifecycle
previous
Product Category
Teradata® Vantage™ NewSQLEngine
To... the user must have...
create a role or external role the CREATE ROLE privilege (system level).
drop a role or external role one of the following privileges:
  • DROP ROLE privilege (system level)
  • role membership WITH ADMIN OPTION
grant privileges to a role, or grant role membership The role granted WITH ADMIN OPTION.
The creator of a role is automatically granted the specified role WITH ADMIN OPTION.