:

ORA-01031 insufficient privileges – Scheduler

The Problem

You are attempting to create a chain using dbms_scheduler, but you are receiving the following error:

ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_ISCHED”, line 3761
ORA-06512: at “SYS.DBMS_ISCHED”, line 772
ORA-06512: at “SYS.DBMS_SCHEDULER”, line 1236
ORA-06512: at line 2

The Cause

You don’t have the appropriate privileges to complete this action.

The Solution

Grant the following privileges to your user, by replacing USER1 with your username. This needs to be run as a high level user; most likely SYS.

begin
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_RULE_OBJ, ‘USER1’);
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, ‘USER1’);
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, ‘USER1’);
end;
/

If you are having problems just trying to submit a job and are receiving an ORA-27486: insufficient privileges error message, you will need to take different action first.

Like it, share it...

Category: Scheduler


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *