ORA-06508: PL/SQL: could not find program unit being called: "PROTECT.ID_INCIDENTDELETOR"

Products

• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

ERROR CODE/ MESSAGE:
07 Sep 2012 00:01:30,293- Thread: 18 SEVERE [com.vontu.manager] Incident deletion failed. Incident deletion failed
07 Sep 2012 00:01:30,325- Thread: 18 SEVERE [com.vontu.manager] Incident Deletion Failed
Cause:
java.sql.SQLException: ORA-04063: package body "PROTECT.ID_INCIDENTDELETOR" has errors
ORA-06508: PL/SQL: could not find program unit being called: "PROTECT.ID_INCIDENTDELETOR"
ORA-06512: at line 1

Cause

Not all privileges were granted on the creation of the "Protect" user.

Resolution

1. Refer to Verify or Grant Oracle Database Privileges to Protect User to ensure all privileges are correctly set.

 

 

Additional Information

The following permissions were missing for the protect user on the database :

PRIVILEGE                                TABLE_NAME
     ---------------------------------------- ------------------------------
     DEBUG                                    DBMS_MONITOR
     EXECUTE                                DBMS_MONITOR
     SELECT                                   DBA_DATA_FILES
     SELECT                                   DBA_EXTENTS
     SELECT                                   DBA_SEGMENTS
     SELECT                                   DBA_TABLESPACES
     SELECT                                   DBA_TEMP_FILES
     SELECT                                   V_$DATABASE
     SELECT                                   V_$INSTANCE
     SELECT                                   V_$PARAMETER
     SELECT                                   V_$SESSION
     SELECT                                   V_$SQLAREA
     EXECUTE                                DBMS_LOCK
     SELECT                                   V_$SQL
     SELECT                                   V_$SQL_PLAN
     SELECT                                   V_$SQL_PLAN_STATISTICS_ALL