Users missing create job priv

Seeing this in 19c for a lot of new users that we are building out.

It seems that users are missing the create job priv, needs to be added.

From Oracle Metalink.

In 19c Database "ORA-27486: insufficient privileges" Error Encountered. 

(Doc ID 2608325.1)

ERROR at line 1:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 9387
ORA-06512: at "SYS.DBMS_ISCHED", line 9376
ORA-06512: at "SYS.DBMS_ISCHED", line 175
ORA-06512: at "SYS.DBMS_ISCHED", line 9302
ORA-06512: at "SYS.DBMS_IJOB", line 196
ORA-06512: at "SYS.DBMS_JOB", line 168
ORA-06512: at line 3

CAUSE

....... user does not have create job privilege.
It is a known issue and an enhancement bug is already there to fix this privilege issue.

SOLUTION

Please grant the following to ...... user and the script works fine after that:

SQL> grant create job to .......;





No comments:

Post a Comment