Originally posted by tansdot
I have a procedure that does an update to a table owned by a user A.
I create a public synonym for this procedure and grant execute on this procedure to a Role which is then granted to User B.

thx
Try granting the excute priveledge directly to the user B rather that through a role..

regards
Hrishy