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.

CASCADE

Moves all users assigned to the profile or profiles being dropped to the DEFAULT profile. If you do not include CASCADE in the DROP PROFILE command and a targeted profile has users assigned to it, the command returns an error.

Privileges

Must be a superuser to drop a profile.

Notes

You cannot drop the DEFAULT profile.

Example

=> DROP PROFILE sample_profile;

See Also