DROP ROLE

Syntax

Purpose

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.

For information on creating roles, see "CREATE ROLE". For information on disabling roles for the current session, see "SET ROLE".

Prerequisites

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

Keywords and Parameters

role	is the role to be dropped.

Example

To drop the role FLORIST, issue the following statement:

DROP ROLE florist;