Skip Headers

Oracle® Database SQL Reference
10g Release 1 (10.1)

Part Number B10759-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

DROP ROLE

Purpose

Use the DROP ROLE statement to remove a role from the database. When you drop a role, Oracle Database revokes it from all users and roles to whom it has been granted and removes it from the database. User sessions in which the role is already enabled are not affected. However, no new user session can enable the role after it is dropped.


See Also:

  • CREATE ROLE and ALTER ROLE for information on creating roles and 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


drop_role::=
Description of drop_role.gif follows
Description of the illustration drop_role.gif

Semantics


role

Specify the name of the role to be dropped.

Example


Dropping a Role: Example

To drop the role dw_manager, which was created in "Creating a Role: Example", issue the following statement:

DROP ROLE dw_manager;