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)
role_name
Name of the role to drop.
database_name
Containing database for role_name.
user_name
Containing user for role_name.
EXTERNAL
Specifies that the role to be dropped is an external role:
  • For a database role, you cannot specify EXTERNAL.
  • For an external role, you must specify EXTERNAL.

Example: Dropping a Role

This request drops the role named temp_admin.

     DROP ROLE temp_admin;

Example: Dropping an External Role

This request drops the external role named rhh.

     DROP EXTERNAL ROLE rhh;