DROP PROFILE v15

Name

DROP PROFILE Drop a user-defined profile.

Synopsis

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

Description

Include the IF EXISTS clause to prevent an error if the specified profile doesn't exist. Instead, issue a notice.

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 prevent dropping any profile that's associated with a role. This is the default behavior.

Parameters

profile_name

The name of the profile to drop.

Examples

This example drops a profile named acctg_profile. The command first associates any roles associated with the acctg_profile profile with the default profile and then drops the acctg_profile profile.

DROP PROFILE acctg_profile CASCADE;

This example drops a profile named acctg_profile. The RESTRICT clause prevents dropping acctg_profile if any roles are associated with the profile.

DROP PROFILE acctg_profile RESTRICT;

See also

CREATE PROFILE, ALTER PROFILE