Re: Some people can't execute a procedure
Date: Thu, 21 Feb 2008 14:58:19 -0700
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 database.
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.
> *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
> 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?