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 - OIC Agent Health Check Service Using OIC Monitoring API

In many Oracle Integration Cloud (OIC) implementations, on-premise and hybrid integrations depend heavily on Connectivity Agents. If an agen...