Oracle7 Server SQL Reference

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:

If the profile's creation label is higher than your DBMS label, you must have READUP and WRITEUP system privileges

If the profile's creation label is lower than your DBMS label, you must have WRITEDOWN system privilege.

If the profile's creation label and your DBMS label are not comparable, you must have READUP, WRITEUP, and WRITEDOWN system privileges.

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.