Running DBMS_SCHEDULER.PURGE_LOG from a Procedure/Package: ORA-27486
9984Jan 24 2007 — edited Jan 24 2007I have a user, USER_1, that has created a program and a job, JOB_1, associated with that program. I need for USER_1, the owner/creator of the job, to be able to execute JOB_1 in a package.
Within the package is a call to DBMS_SCHEDULER.PURGE_LOG and a call to DBMS_SCHEDULER.RUN_JOB. Even though the owner of the job is creating this procedure, which compiles fine, executing it returns this error:
ORA-27486: insufficient privileges
I realize a role won't solve this. Of course, it runs fine from SQL*Plus. I have reviewed all the system privileges and don't understand which privilege I might be missing. Any suggestions would be appreciated.
Thanks.
Bob