Re: ORA-01720: grant option does not exist for 'S.P'
From: Dwaraknath Krishnamurthi <dwarak.k_at_gmail.com>
Date: Tue, 10 Nov 2009 18:08:02 +0530
Message-ID: <607321dc0911100438j51d32faate81ef2397709fbfe_at_mail.gmail.com>
Thanks for the immediate response
Date: Tue, 10 Nov 2009 18:08:02 +0530
Message-ID: <607321dc0911100438j51d32faate81ef2397709fbfe_at_mail.gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 10 2009 - 06:38:02 CST