Purpose

Use the DROP LOCKDOWN PROFILE statement to remove a PDB lockdown profile from the database.

If the lockdown profile is the value of the PDB_LOCKDOWN initialization parameter for a CDB, an application root, or a PDB, then the effect of the lockdown profile will be disabled when you drop it. However, the lockdown profile will remain as the value of the PDB_LOCKDOWN initialization parameter. You can subsequently modify the PDB_LOCKDOWN parameter to unset the value of the dropped lockdown profile.

Prerequisites

The DROP LOCKDOWN PROFILE statement is valid only in a CDB. The current container must be the CDB root and you must have the DROP LOCKDOWN PROFILE system privilege, either granted commonly or granted locally in the CDB root.

Syntax

drop_lockdown_profile::=

Description of the illustration drop_lockdown_profile.eps

Semantics

profile_name

Specify the name of the PDB lockdown profile to be dropped.

You can find the names of existing PDB lockdown profiles by querying the DBA_LOCKDOWN_PROFILES data dictionary view.

Example

The following statement drops PDB lockdown profile hr_prof:

DROP LOCKDOWN PROFILE hr_prof;