RE: Some people can't execute a procedure
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <andert@xxxxxxxxx>, "Oracle L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Feb 2008 14:05:08 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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?
Other related posts:
