Re: Invoker Rights - Am I missing Something.

connect as A.
grant execute on testme1.process to B.

hth.

SMiller <____steve.miller_at_redeye.com> wrote in message ...
>Close Scott....but not quite.
>
>I made your suggested code changes but the job is still sitting in the
>queue. At least the insert is commited when I force it to run now.
>
>I can perform an exec dbms_job.run(xxx); and the job will run and be
 cleared
>from the queue, but it won't happen from the call to the package.
>
>Any other ideas?
>
>
>
>"Scott Watson" <swatson_at_datachest.com> wrote in message
>news:vaUK6.16007$yw.546717_at_news20.bellglobal.com...
>> I read somewhere that after submitting a job it is always advisable to
 issue
>> a commit; I don't remember the exact reason but it had something to do
 with
>> the job not running.
>>
>> However to get you code to work as you laid it out I would do something
 like
>>
>> stmnt := 'insert into test values (1, 2, 3); commit;';
>> DBMS_JOB.submit(jobnum, stmnt);
>> commit;
>>
>>
>> HTH
>> Scott.
>>
>> "SMiller" <____steve.miller_at_redeye.com> wrote in message
>> news:HRTK6.61461$PP3.4242226_at_nnrp3.clara.net...
>> > Oracle 8.1.7 on Linux.
>> > ----------------------
>> > I have 2 users created......A and B.
>> >
>> > I perform the following in B.
>> > create table test (one number, two number, three number);
>> > grant insert, update, delete on test to public;
>> >
>> > Then, I perform the following in A.
>> >
>> > CREATE OR REPLACE PACKATE testme1
>> > authid current_user IS
>> >
>> > Procedure process;
>> >
>> > end testme1;
>> >
>> > CREATE OR REPLACE PACKAGE BODY testme1 IS
>> >
>> > procedure process is
>> > jobnum INTEGER;
>> > stmnt VARCHAR2(1000);
>> > x integer;
>> > BEGIN
>> > insert into redeyedev.test values (9, 9, 9);
>> > commit;
>> > stmnt := 'insert into test values (1, 2, 3);';
>> > DBMS_JOB.submit(jobnum, stmnt);
>> > stmnt := 'commit;';
>> > DBMS_JOB.submit(jobnum, stmnt);
>> >
>> > END process;
>> >
>> > end testme1;
>> >
>> > Finally I perform the following in B.
>> > exec a.testme1.process;
>> >
>> > Table test has 9, 9, 9 inserted as expected.
>> > BUT
>> > DBA_JOBS has the job in the jobqueue but it does not get run.
>> > Table test does not have 1, 2, 3 inserted as the job has not been
 executed.
>> >
>> > Am I missing a grant somewhere, or is the above example not possible?
>> >
>> > Is there a better way of doing this?
>> >
>> >
>> >
>> >
>>
>>
>
>
Received on Sat May 19 2001 - 15:56:22 CDT