Oracle8i SQL Reference
Release 2 (8.1.6)

A76989-01

Library

Product

Contents

Index

Prev Up Next

SQL Statements (continued), 17 of 30


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; 

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index