Re: ORA-01720: grant option does not exist for 'S.P'

From: Dwaraknath Krishnamurthi <dwarak.k_at_gmail.com>
Date: Wed, 11 Nov 2009 18:55:31 +0530
Message-ID: <607321dc0911110525v2d043403rd588d6e066762731_at_mail.gmail.com>



Hi Folks,
I further tried providing these privileges and I still face the same issue
grant execute on S.P to public with grant option;
grant execute on S.P to S with grant option;
grant execute on S.P to R;

When I tried to run
GRANT SELECT ON S.V to R

I still encounter this error

ORA-01720: grant option does not exist for 'S.P'

Any Clues?

Thanks,
Dwarak.K

On Tue, Nov 10, 2009 at 6:08 PM, Dwaraknath Krishnamurthi < dwarak.k_at_gmail.com> wrote:

> Thanks for the immediate response
>
> I tried to issue the grant and got an error
> grant EXECUTE ON S.P TO R with grant option
>
> ERROR at line 1:
> ORA-01926: cannot GRANT to a role WITH GRANT OPTION
>
> Thanks,
> *Dwarak
> *
>
> On Tue, Nov 10, 2009 at 5:15 PM, vit.spinka <vit.spinka_at_vitspinka.cz>wrote:
>
>> > I have already run this grant successfully
>> > GRANT EXECUTE ON S.P TO R
>>
>> You have to use "grant execute on s.p to r with grant opton". If you grant
>> select on s.v to others, you in fact indirectly want to grant execute on s.p
>> to them (a bit) - and thus need the grant option.
>>
>>
>
>
> --
> Thanks,
> Dwarak.K
> Oracle India Pvt ltd
> 9866325254
>

-- 
Thanks,
Dwarak.K
Oracle India Pvt ltd
9866325254

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 11 2009 - 07:25:31 CST

Original text of this message