Some people can't execute a procedure

From: "Stephen Andert" <andert@xxxxxxxxx>
To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 21 Feb 2008 11:55:38 -0700

USER_A cannot execute a procedure owned by USER_B when one person logs in.
USER_A *can* execute a procedure owned by USER_B when a different person
logs in.

One person is in one city and the other is in a different city, but in TOAD,
both users can "see" the procedure when browsing the procedures of USER_B.

Furthermore, this is only the case in one environment (DEV) and works
normally in other environments (i.e. QA)

I have confirmed (in TOAD and SQL*Plus) that USER_A has EXECUTE privs on the
procedure granted by USER_B.

Help.  What else can I try?

Follow-Ups:

RE: Some people can't execute a procedure
From: Mercadante, Thomas F (LABOR)

Re: Some people can't execute a procedure
From: Andrew Kerber

Re: Some people can't execute a procedure
From: Don Seiler

RE: Some people can't execute a procedure
From: Hostetter, Jay M

Some people can't execute a procedure

Other related posts: