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