DROP DATA ROLE

Purpose

Use DROP DATA ROLE to drop a data role.

Prerequisites

You must have the DROP DATA ROLE system privilege to execute this command.

Syntax

Description of the illustration drop_data_role.gif

Semantics

• IF EXISTS: If you specify IF EXISTS the data role is dropped if it exists. If the data role does not exist, no error is thrown.

  If you do not specify IF EXISTS, and the data role exists, then it will be dropped. If the data role does not exist, an error is thrown.

• data_role : the name of the data role to be dropped.

Example

The following SQL statement drops the existing data role, manager_role:

DROP DATA ROLE manager_role;