Problem :
When running dbms_scheduler.add_event_queue_subscriber() using the job owner ( not SYS )
and hitting the following error :
ERROR at line 1:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 2959
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2242
ORA-06512: at line 1
Solution :
grant CREATE JOB to '{JOB_OWNER}';
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment