DROP PROFILE

Purpose

Use the DROP PROFILE statement to remove a profile from the database.

See Also: CREATE PROFILE for information on creating a profile ALTER PROFILE for information on modifying a profile

Prerequisites

You must have the DROP PROFILE system privilege.

Syntax

Keywords and Parameters

profile

Specify the name of the profile to be dropped.

Restriction: You cannot drop the DEFAULT profile.

CASCADE

Specify CASCADE to deassign 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

DROP PROFILE 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.