Tuesday, June 18, 2024

Db - insufficient privileges issue while using dbms_scheduler create job

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

Featured Post

OIC Accelerator Upgrade: Reviewing Merge Reports and Resolving Unmerged Extensions

Working... When upgrading an Oracle Integration Cloud (OIC) Accelerator, Oracle automatically merges the latest accelerator changes with you...