SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06512: at "SYS.DBMS_ISCHED"

supersenAug 14 2020 — edited Aug 15 2020

Hi All

I am getting error while deploying job in new db

exec DBMS_SCHEDULER.create_job(...

ORA-27486: insufficient privileges

ORA-06512: at "SYS.DBMS_ISCHED", line 99

ORA-06512: at "SYS.DBMS_SCHEDULER", line 268

ORA-06512: at line 2

I want to know the user has DBMS_SCHEDULER privilege AND create job privilege or not

if yes then i can grant these privileges. I queried dba_sys_privs NOT getting required output to show the privs for user. Please help

grant execute on DBMS_SCHEDULER to <myuser>;

grant create job to <myuser>;

Supersent

Added on Aug 14 2020

1 comment

17,556 views