3.3.44 DROP PROFILE

Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.44 DROP PROFILE

DROP PROFILE – drop a user-defined profile
DROP PROFILE [IF EXISTS] profile_name [CASCADE | RESTRICT];
Include the IF EXISTS clause to instruct the server to not throw an error if the specified profile does not exist. The server will issue a notice if the profile does not exist.
Include the optional CASCADE clause to reassign any users that are currently associated with the profile to the default profile, and then drop the profile. Include the optional RESTRICT clause to instruct the server to not drop any profile that is associated with a role. This is the default behavior.
The command first re-associates any roles associated with the acctg_profile profile with the default profile, and then drops the acctg_profile profile.
The RESTRICT clause in the command instructs the server to not drop acctg_profile if there are any roles associated with the profile.

3 The SQL Language : 3.3 SQL Commands : 3.3.44 DROP PROFILE

Table of Contents Previous Next