16.20 - role_name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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.

Example: Creating an External Role

The following request creates an external role named rhh that is managed by the Teradata Database, for use in assigning privileges to users in a directory:

    CREATE EXTERNAL ROLE rhh;