dbms_scheduler insufficient privileges,ORA-01031

Below error will occur while User accessing DBMS_SCHEDULER, so necessary permission need to give.

Error code:

ORA-01031: insufficient
privileges
ORA-06512: at
“SYS.DBMS_ISCHED”
ORA-06512: at
“SYS.DBMS_ISCHED”
ORA-06512: at
“SYS.DBMS_SCHEDULER”

Solution:

GRANT CREATE JOB TO <user name>
GRANT CREATE EVALUATION CONTEXT <username>
GRANT CREATE RULE <user name>

  • June 22, 2018 | 35 views
  • Comments