ORA-41727
insufficient privileges for DROP PROFILE
Cause
An attempt was made to:
- Drop a common profile in root without the commonly granted DROP PROFILE privilege.
- Drop a federation profile in federation root without the federationally granted DROP PROFILE privilege.
- Drop a protected profile in PDB without the commonly granted DROP PROFILE privilege even though profile is local to PDB
Action
Grant the required privilege and retry the operation.