CREATE ROLE in Teradata

Creates a role for managing user access privileges on database objects.

Syntax:
CREATE [EXTERNAL] ROLE role_name;


Example 1:
The following requests create roles named management and administration:
CREATE ROLE management;
CREATE ROLE administration;

Example 2
The following request creates an external role named rhh that is managed by the Teradata Database:
CREATE EXTERNAL ROLE rhh;