|Oracle8i SQL Reference
Release 2 (8.1.6)
SQL Statements (continued), 16 of 30
To remove a profile from the database.
For information on creating a profile, see "CREATE PROFILE".
You must have the
PROFILE system privilege.
Restriction: You cannot drop the
deassigns the profile from any users to whom it is assigned. Oracle automatically assigns the
The following statement drops the profile
Oracle drops the profile
ENGINEER and assigns the
DEFAULT profile to any users currently assigned the