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
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.
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 .......;
SQL> grant create job to .......;
No comments:
Post a Comment