15.10 - role_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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;