Synopsis
DROP PROFILE profile_name
[CASCADE]
Removes a profile ( profile_name) from the
database.
Keyword
- CASCADE
Specifies that this profile is to be deassigned from all users to
whom it is assigned, and replaced with the DEFAULT profile.
Notes
You must have the DROP PROFILE privilege to remove a profile. You
cannot remove the DEFAULT profile.
Example
The following example removes the admin profile from the database:
DROP PROFILE admin