Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C874C4.AFE45664"
Subject: RE: Some people can't execute a procedure
Date: Thu, 21 Feb 2008 15:02:29 -0500
Message-ID: <D67EB7CEECD4334F9C85759227553BBC0B4B4875@CL-EXCHANGE1.dande.com>
In-Reply-To: <6d45e210802211055y391a9a1amcd36099b0857119d@mail.gmail.com>
Thread-Topic: Some people can't execute a procedure
From: "Hostetter, Jay M" <JHostetter@decommunications.com>
To: <andert@gmail.com>,
 "Oracle L" <oracle-l@freelists.org>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: JHostetter@decommunications.com
------_=_NextPart_001_01C874C4.AFE45664
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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@freelists.org
[mailto:oracle-l-bounce@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?


**DISCLAIMER=0A=
This e-mail message and any files transmitted with it are intended for the u=
se of the individual or entity to which they are addressed and may contain i=
nformation that is privileged, proprietary and confidential. If you are not=
 the intended recipient, you may not use, copy or disclose to anyone the mes=
sage or any information contained in the message. If you have received this=
 communication in error, please notify the sender and delete this e-mail mes=
sage. The contents do not represent the opinion of D&E except to the extent=
 that it relates to their official business.

------_=_NextPart_001_01C874C4.AFE45664
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1605" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D579445819-21022008><FONT face=3DAr=
ial 
color=3D#0000ff size=3D2>After you try Don's suggestions, verify that they a=
re 
hitting the same database.&nbsp; Since they're in a different city, they cou=
ld 
be using a different TNSNAMES file. Tell them to send you the results of a 
tnsping.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D579445819-21022008><FONT face=3DAr=
ial 
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D579445819-21022008><FONT face=3DAr=
ial 
color=3D#0000ff size=3D2>Jay</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D579445819-21022008><FONT face=3DAr=
ial 
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> oracle-l-bounce@freelists.org 
[mailto:oracle-l-bounce@freelists.org] <B>On Behalf Of </B>Stephen 
Andert<BR><B>Sent:</B> Thursday, February 21, 2008 1:56 PM<BR><B>To:</B> Ora=
cle 
L<BR><B>Subject:</B> Some people can't execute a procedure<BR></FONT><BR></D=
IV>
<DIV></DIV><BR>USER_A cannot execute a procedure owned by USER_B when one pe=
rson 
logs in.<BR>USER_A <U><B>can</B></U> execute a procedure owned by USER_B whe=
n a 
different person logs in.<BR><BR>One person is in one city and the other is=
 in a 
different city, but in TOAD, both users can "see" the procedure when browsin=
g 
the procedures of USER_B.<BR><BR>Furthermore, this is only the case in one 
environment (DEV) and works normally in other environments (i.e. QA)<BR><BR>=
I 
have confirmed (in TOAD and SQL*Plus) that USER_A has EXECUTE privs on the 
procedure granted by USER_B.<BR><BR>Help.&nbsp; What else can I 
try?<BR><BR><BR><p>**DISCLAIMER=0A=
This e-mail message and any files transmitted with it are intended for the u=
se of the individual or entity to which they are addressed and may contain i=
nformation that is privileged, proprietary and confidential. If you are not=
 the intended recipient, you may not use, copy or disclose to anyone the mes=
sage or any information contained in the message. If you have received this=
 communication in error, please notify the sender and delete this e-mail mes=
sage. The contents do not represent the opinion of D&E except to the extent=
 that it relates to their official business.</p>
</BODY></HTML>

------_=_NextPart_001_01C874C4.AFE45664--
--
http://www.freelists.org/webpage/oracle-l