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.
PROFILE statement is valid only in a CDB. The current container must be the CDB root and you must have the
PROFILE system privilege, either granted commonly or granted locally in the CDB root.
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.
The following statement drops PDB lockdown profile
DROP LOCKDOWN PROFILE hr_prof;