Hi guys
I have a possible clue on what could be the problem, but I cannot figure how to fix it
I have a procedure that does DBMS_SCHEDULER.stop_JOB (job_name => r.job_name,force=>true);
the procedure works fine if called manually (ie exec <procedure>), but called by a job (job defined by the same user) fails with
"ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 199
ORA-06512: at "SYS.DBMS_SCHEDULER", line 557
ORA-06512: at "SIEBEL_DBA.KILL_F5_JOBS_OVERRUNNNING", line 24 --> the line with stop job
"
Now off-course it will fail because scheduler raises a new session (under oracle user) and IF it executes under current user perhaps cannot stop other users jobs... BUT the procedure is defined like so:
create or replace procedure kill_F5_jobs_overrunnning as
begin
...
and afaik default is DEFINER rights
So what am I missing here
ps: also i'm trying to stop my jobs
Thanks
Florin