Database Error Messages

ORA-41727

insufficient privileges for DROP PROFILE

Cause

An attempt was made to:

  1. Drop a common profile in root without the commonly granted DROP PROFILE privilege.
  2. Drop a federation profile in federation root without the federationally granted DROP PROFILE privilege.
  3. 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.