RE: Some people can't execute a procedure

From: Hostetter, Jay M <>
Date: Thu, 21 Feb 2008 15:02:29 -0500
Message-ID: <>

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.  


[] 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.

Received on Thu Feb 21 2008 - 14:02:29 CST

Original text of this message