ORA-27486: insufficient privileges

The Problem

When attempting to submit a job via dbms_scheduler, you receive the following error:

ORA-27486: insufficient privileges
ORA-06512: at “SYS.DBMS_ISCHED”, line 5
ORA-06512: at “SYS.DBMS_SCHEDULER”, line 30

The Cause

You don’t have appropriate permissions to create jobs in this way.

The Solution

You will need to grant the appropriate privileges to the user in order to submit jobs successfully. This is an example to fix the problem seen above for USER1:

GRANT CREATE JOB TO USER1;

If you find that you have already done this and still can’t submit your job, it might be because you are trying to submit a chain. In which case, you could be hitting the ORA-01031: insufficient privileges error message. This message is usually encountered after first performing this step, so make sure you are looking at the correct error message.

Like it, share it...

Category: Scheduler