RE: Some people can't execute a procedure

Stephen,  

Do you get an error message when the 2nd person tries to execute the package? Or does the screen freeze?  

What do you mean?  

Tom

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stephen Andert Sent: Thursday, February 21, 2008 1:56 PM To: Oracle L
Subject: Some people can't execute a procedure

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?

--
http://www.freelists.org/webpage/oracle-l