ORA-01031: insufficient privileges(有待于二次解决)

问题描述:在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');

posted @ 2013-05-30 07:33  ArcerZhang  阅读(552)  评论(1编辑  收藏  举报