Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

job insufficient privileges

User_EF4YWJul 21 2016 — edited Jul 21 2016

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2016
Added on Jul 21 2016
1 comment
856 views