Re: Some people can't execute a procedure

Check if the user in Chicago has a sqlnet.ora file. This should show up if he/she does a tnsping. If there is, inspect the content. Compare it to your own sqlnet.ora. If there are differences, either replace the Chicago sqlnet.ora file with your own or remove it altogether. I don't know of a sqlnet.ora parameter that would cause this, but it's all I can think of.

Finn

On Thu, Feb 21, 2008 at 5:04 PM, Stephen Andert <andert_at_gmail.com> wrote:

> I read the list a lot, but I guess I don't participate enough since I'm
> not used to the automatic "reply to sender" instead of "reply to list". LOL
>
> On Thu, Feb 21, 2008 at 12:20 PM, Stephen Andert <andert_at_gmail.com> wrote:
>
> > Andrew,
> >
> > Sorry, I forgot to mention:
> >
> > DEV is still 9.2.0.2 (not work for some users)
> > QA and above is 9.2.0.4 (does work for all tested users)
> > Both servers are Solaris 5.8
> >
> > Error:
> > The user in Chicago gets this:
> >
> > ORA-06550: line 2, column 16:
> > PLS-00904: insufficient privilege to access object USER_B.PROCEDURE_NAME
> > ORA-06550: line 2, column 3:
> > PL/SQL: Statement ignored
> > I get:
> >
> > Procedure Completed
> >
> > Thanks
> >
> >
> > On Thu, Feb 21, 2008 at 12:11 PM, Andrew Kerber <andrew.kerber_at_gmail.com>
> > wrote:
> >
> > > oracle version, OS, and error message?
> > >
> > >
> > > On Thu, Feb 21, 2008 at 12:55 PM, Stephen Andert <andert_at_gmail.com>
> > > wrote:
> > >
> > > >
> > > > 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?
> > > >
> > > >
> > > >
>

--
http://www.freelists.org/webpage/oracle-l