Re: Some people can't execute a procedure
Date: Fri, 22 Feb 2008 18:01:44 -0700
I will do that next, after the remote user tries logging on at another machine to see if it happens there or not. They are pretty busy, so hopefully he will try it over the weekend.
On Fri, Feb 22, 2008 at 7:43 AM, Baumgartel, Paul < paul.baumgartel_at_credit-suisse.com> wrote:
> Have you tried setting an extended trace (via dbms_support, or set event
> 10046) on each session before attempting to execute? The trace file will
> show you everything that goes on, including recursive SQL.
> Does the problem occur when the client is SQL*Plus, or only when it's
> *Paul Baumgartel*
> *CREDIT SUISSE*
> Information Technology
> Prime Services Databases Americas
> One Madison Avenue
> New York, NY 10010
> Phone 212.538.1143
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Stephen Andert
> *Sent:* Thursday, February 21, 2008 4:58 PM
> *To:* Oracle L
> *Subject:* Re: Some people can't execute a procedure
> Good idea, and I just verified this. The person in the other city has an
> identical result to min. A few ms longer, but same host ip and
> service_name. Furthermore, the usernames in question only exist in this one
> Great ideas everyone, but still have not found an answer so any more
> ideas are welcome, no matter if they sound crazy or not.
> I am having other users in the other city test and having the first
> developer (with the problem) try logging in to another machine to see if it
> is a network or PC problem. I'll keep the list updated.
> On Thu, Feb 21, 2008 at 1:02 PM, Hostetter, Jay M <
> JHostetter_at_decommunications.com> wrote:
> > 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_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?