While we are executing a package /procedure which contains a dbms_scheduler.create job. This is giving insufficient priviledge issue.
Error:
ERROR at line 1:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 2
Solution: Run the below command:
grant create job to user_name;
No comments:
Post a Comment