CREATE ROLE Syntax Elements - Teradata Vantage - Analytics Database
SQL Data Definition Language Syntax and Examples
- Deployment
- VantageCloud
- VantageCore
- Edition
- VMware
- Enterprise
- IntelliFlex
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2025-11-22
- dita:mapPath
- jco1628111346878.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- mdr1472255012272
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- EXTERNAL
- 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™ - Analytics Database Security Administration, B035-1100.
- role_name
- 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.