DROP ROLE

Purpose

Use the DROP ROLE statement to remove a role from the database. When you drop a role, Oracle revokes it from all users and roles to whom it has been granted and removes it from the database.

See Also: CREATE ROLE for information on creating roles ALTER ROLE for information on changing the authorization needed to enable a role SET ROLE for information on disabling roles for the current session

Prerequisites

You must have been granted the role with the ADMIN OPTION or you must have the DROP ANY ROLE system privilege.

Syntax

Keywords and Parameters

role

Specify the name of the role to be dropped.

Example

DROP ROLE Example

To drop the role florist, issue the following statement:

DROP ROLE florist;