Re: Some people can't execute a procedure
- From: "Stephen Andert" <andert@xxxxxxxxx>
- To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Feb 2008 15:04:06 -0700
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@xxxxxxxxx> 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@xxxxxxxxx>
> wrote:
>
> > oracle version, OS, and error message?
> >
> >
> > On Thu, Feb 21, 2008 at 12:55 PM, Stephen Andert <andert@xxxxxxxxx>
> > 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?
> > >
> > >
> > >
Other related posts:
