Oracle7 Server SQL Reference

Contents Index Home Previous Next

DROP PROFILE

Purpose

To remove a profile from the database.

Prerequisites

You must have DROP PROFILE system privilege.

If you are using Trusted Oracle7 in DBMS MAC mode, your DBMS label must match the profile's creation label or you must satisfy one of the following criteria:

Syntax

Keywords and Parameters

profile

is the name of the profile to be dropped.

CASCADE

de-assigns the profile from any users to whom it is assigned. Oracle7 automatically assigns the DEFAULT profile to such users. You must specify this option to drop a profile that is currently assigned to users.

Usage Notes

You cannot drop the DEFAULT profile.

Example

The following statement drops the profile ENGINEER:

DROP PROFILE engineer 
	CASCADE 

Oracle7 assigns the DEFAULT profile to any users currently assigned the ENGINEER profile.

Related Topics

CREATE PROFILE command [*]


Contents Index Home Previous Next