> 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.
