You can use the DROP PROFILE statement to drop a profile. The statement has the following syntax:

DROP PROFILE [IF EXISTS] profile_name [CASCADE|RESTRICT];

The IF EXISTS clause specifies that the server does not return an error if the specified profile does not exist. The server generates a notification if the profile does not exist.

You can use the optional CASCADE clause to reassign any users that are associated with the profile to the default profile and then drop the profile. The optional RESTRICT clause specifies that the server does not drop any profile that is associated with a role. This is the default behavior.

Parameters

Parameter Description
profile_name The name of the profile to be dropped.

Examples

The following example drops a profile named acctg_profile:

DROP PROFILE acctg_profile CASCADE;

The statement associates any roles associated with the acctg_profile profile with the default profile again and then drops the acctg_profile profile.

The following example drops a profile named acctg_profile:

DROP PROFILE acctg_profile RESTRICT;

The RESTRICT clause in the statement specify that the server does not drop acctg_profile if any roles are associated with the profile.