Monday, November 3, 2008

ORA-27486: insufficient privileges when running dbms_scheduler.add_event_queue_subscriber()

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}';

No comments: