RE: Some people can't execute a procedure
- From: "Hostetter, Jay M" <JHostetter@xxxxxxxxxxxxxxxxxxxx>
- To: <andert@xxxxxxxxx>, "Oracle L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Feb 2008 15:02:29 -0500
After you try Don's suggestions, verify that they are hitting the same
database. Since they're in a different city, they could be using a
different TNSNAMES file. Tell them to send you the results of a tnsping.
Jay
________________________________
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?
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use
of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the message
or any information contained in the message. If you have received this
communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the extent
that it relates to their official business.
Other related posts:
