DROP PROFILE
DROP PROFILE — remove a security profile
Synopsis
DROP PROFILE [IF EXISTS] name
Description
DROP PROFILE removes a security profile from the system.
A security profile can only be dropped by a database system administrator or a superuser.
When there are users assigned to this security profile, DROP PROFILE will
throw a runtime error.
Parameters
IF EXISTS
Do not throw an error if the security profile does not exist. A notice is issued in this case.
name
The name of an existing security profile.
Examples
To drop a security profile:
DROP PROFILE profile123;
Compatibility
There is no DROP PROFILE statement in the SQL standard.