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
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;