Is it the USER that has the execute privs, or some role granted to the user? If so, is the role a default role? If not default, is there a logon trigger that conditionally sets the role upon user login? Don. On Thu, Feb 21, 2008 at 12:55 PM, Stephen Andert <andert@xxxxxxxxx> wrote: > > 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? > > > -- Don Seiler http://seilerwerks.wordpress.com ultimate: http://www.mufc.us -- //www.freelists.org/webpage/oracle-l