Dropping a password profile v18

The PG_DROP_PROFILE function drops a password profile.

Synopsis

PASSWORD_PROFILE.PG_DROP_PROFILE('profilename',
                                 missing_ok)

Description

PG_DROP_PROFILE drops the specified password profile for password management.

To use PG_DROP_PROFILE, you must not have any users assigned to the profile.

Parameters

• profilename — Name of the password profile to drop.

• missing_ok — If set to true, the function does not raise an error if the specified profile does not exist. If set to false, an error is raised when the specified profile does not exist.

See also

CREATE PROFILE, MODIFYING A PROFILE