17.05 - CREATE ROLE Syntax Elements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
Content Type
Programming Reference
Publication ID
English (United States)
Last Update
The role named by role_name is an external role.
External roles exist in the database, but can only be assigned to users in an LDAP-compliant directory.
For information about how to create directory objects that correspond to database external roles and map the objects to directory users (using group objects), see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.
Name of the role.
For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
Database and external roles share the same name space.
Databases and external roles can have the same name as a profile, table, column, view, macro, trigger, table UDF, external SQL procedure, method, UDT, or SQL procedure. However, role names must be unique among users and databases.