Database Utilities (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center