DROP PROFILE

Syntax

Purpose

To remove a profile from the database.

For information on creating a profile, see "CREATE PROFILE".

Prerequisites

You must have the DROP PROFILE system privilege.

Keywords and Parameters

profile	is the name of the profile to be dropped. Restriction: You cannot drop the DEFAULT profile.
CASCADE	deassigns the profile from any users to whom it is assigned. Oracle automatically assigns the DEFAULT profile to such users. You must specify this clause to drop a profile that is currently assigned to users.

Example

The following statement drops the profile ENGINEER:

DROP PROFILE engineer CASCADE; 

Oracle drops the profile ENGINEER and assigns the DEFAULT profile to any users currently assigned the ENGINEER profile.