Symantec Data Loss Prevention
When running the incident deletion job, deletion fails.
This error is seen in the localhost.x.log on the Enforce Server:
SEVERE [com.vontu.manager] Incident Deletion Failed
java.sql.SQLException: ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 9387
ORA-06512: at "SYS.DBMS_ISCHED", line 9376
ORA-06512: at "SYS.DBMS_ISCHED", line 175
ORA-06512: at "SYS.DBMS_ISCHED", line 9302
ORA-06512: at "SYS.DBMS_IJOB", line 196
ORA-06512: at "SYS.DBMS_JOB", line 168
ORA-06512: at "PROTECT.ID_INCIDENTDELETOR", line 3314
ORA-06512: at line 1
The database 'protect' user is missing permissions to run the deletion.
Data Loss Prevention 15.5 MP2
In the Oracle 12c database, give the PROTECT user the EXECUTE DBMS_JOB privilege.
If the database is Oracle 19c, then the PROTECT user needs both the EXECUTE DBMS_JOB and CREATE JOB privileges.
grant EXECUTE on DBMS_JOB to protect;
grant create job to protect;