Re: Some people can't execute a procedure

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