Drop Data Role

Use the DROP DATA ROLE command to remove a data role from the database.

Required privilege

The DROP DATA ROLE system privilege.

Syntax

DROP DATA ROLE [ IF EXISTS ] data_role;

Parameters

Parameter	Description
data_role	The name of the data role to be dropped.

Usage notes and restrictions

• When IF EXISTS is specified:

  • If the data role does not exist, the statement is a no-op. No error is raised.

  • If the data role exists, it is dropped.

• When IF EXISTS is omitted:

  • If the data role does not exist, an error is raised.

  • If the data role exists, it is dropped.

For syntax diagrams and additional details, see DROP DATA ROLE in Oracle AI Database SQL Language Reference.

Example: Drop data role

Drop an existing data role, employee_role.

DROP DATA ROLE employee_role;