You must have the
PROFILE system privilege.
Specify the name of the profile to be dropped.
CASCADE to deassign the profile from any users to whom it is assigned. Oracle Database automatically assigns the
DEFAULT profile to such users. You must specify this clause to drop a profile that is currently assigned to users.
Dropping a Profile: Example
The following statement drops the profile
app_user, which was created in "Creating a Profile: Example". Oracle Database drops the profile
app_user and assigns the
DEFAULT profile to any users currently assigned the
DROP PROFILE app_user CASCADE;