PROFILE statement to remove a PDB lockdown profile from the database. A PDB that was assigned the dropped profile will continue to be assigned the profile, but will not be subject to the restrictions imposed by the dropped profile.
PDB_LOCKDOWN initialization parameter for a CDB, an application root, or a PDB has the value of the dropped lockdown profile, then the restrictions imposed by the dropped profile will be disabled when you drop it. However, the value of the
PDB_LOCKDOWN initialization parameter will remain until you explicitly unset it.
You must issue this statement from the CDB Root or the Application Root.
You must have the
PROFILEsystem privilege in the container where you mean to issue the statement.
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;