15.10 - role_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

Name of the role.

For information about naming database objects, see 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;