DROP PROFILE
Removes a profile from the database. Only the superuser can drop a profile.
Syntax
DROP PROFILE name [, ...] [ CASCADE ]
Parameters
name
|
The name of one or more profiles (separated by commas) to be removed. |
|
Moves all users assigned to the profile or profiles being dropped to the DEFAULT profile. If you do not include |
Privileges
Must be a superuser to drop a profile.
Notes
You cannot drop the DEFAULT profile.