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@xxxxxxxxx> 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@xxxxxxxxxxxx>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