问题描述:在sys用户下直接授权grant create job to U3/grant create any job to U3,执行成功后,切换到U3用户后,执行dbms_scheduler.create_chain('my_chain1');会报权限不足的错误.不知道为什么?
begin dbms_scheduler.create_chain('my_chain1'); end; / 4 begin * ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED", line 4856 ORA-06512: at "SYS.DBMS_ISCHED", line 1094 ORA-06512: at "SYS.DBMS_SCHEDULER", line 1598 ORA-06512: at line 2
解决方案:
临时权益之际:grant dba to U3;即可使用dbms_scheduler.create_chain('my_chain1');