Error when creating an AUDSYS owned scheduler job.
I am attempting to create an scheduler job owned by AUDSYS. I sign onto the Oracle database instance as SYSDBA and execute the following:
begin
dbms_scheduler.create_job
(job_name => 'AUDSYS.PURGEAUDITARCHIVE',
job_type => 'STORED_PROCEDURE',
job_action => 'DBAUSER.PR_PURGEAUDITARCHIVE',
schedule_name => 'DBAUSER.DFASARCHIVEPURGE',
job_class => DFASLOGALL7,
comments => 'DFAS purge AUDSYS.DFAS_AUDIT_ARCHIVE table',
enabled => TRUE);
end;
When I do so, I get the following error.
ERROR at line 1:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 175
ORA-06512: at "SYS.DBMS_SCHEDULER", line 424
ORA-06512: at line 7
The "AUDSYS" account has execution privilege on the stored procedure "DBAUSER.PR_PURGEAUDITARCHIVE". The "SYS" account has the "AUDIT_ADMIN" and "AUDIT_VIEWER" roles and the "CREATE ANY JOB" privilege. I am not sure what I am missing.