Trying to stop scheduled job as an non-dba user: myUser
exec DBMS_SCHEDULER.STOP_JOB('myJob',force => true);
ORA-27486 insufficient privilege
ORA-06512 at "SYS.DBMS_ISCHED", line 199
ORA-06512 at "SYS.DBMS_SCHEDULER", line 557
The user is lacking the system privilege: MANAGE SCHEDULER
solution:
grant MANAGE SCHEDULER to myUser;
No comments:
Post a Comment