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.
Related Topics
CREATE PROFILE command