For More Information - Advanced SQL Engine - Teradata Database

SQL Data Control Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
lmb1556233084626.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1149
lifecycle
previous
Product Category
Teradata® Vantage™ NewSQLEngine
Topic Reference Source
Granting privileges on database objects to roles and obtaining the CREATE ROLE system privilege GRANT (SQL Form).
Revoking privileges granted by the Role form of GRANT REVOKE (Role Form)
Granting CONNECT THROUGH proxy connection privileges to a permanent or application user with a set of roles GRANT CONNECT THROUGH
Assigning default roles to users
  • “CREATE USER” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
  • “MODIFY USER” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
Changing the current role for a session “SET ROLE” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
Granting individual privileges and database roles to external roles within Teradata Database. Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100

Teradata Vantage™ - Database Administration, B035-1093