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 File Handling – Removing .pgp and Preserving .csv (Dynamic File Name Logic) | use of ast-index-within-string() function

๐Ÿ“Œ Problem Statement In Oracle Integration Cloud (OIC), while working with Stage File, we often receive source files like: a.b.c.csv.pgp ๐Ÿ” ...