Re: What privilege needs to be granted?
Date: Fri, 02 Jan 2004 10:09:39 +0100
Message-ID: <bt3bur$38u$1_at_news4.tilbu1.nb.home.nl>
Ping wrote:
> Hello,
>
> Have a wonderful new year!
>
> I have oracle 9.2 on XP.
>
> There is a table T1 created by user U1 in U1's schema,
> a synonym S1 created also by U1 to point to T1 in U1's schema,
> U1 granted S1 to public for select.
>
>
> Procedure P2 created by user U2 in U2's schema,
> in P2, the S1 is referenced for select in a cursor.
>
>
> Problem and question:
> when P2 is compiled, got an error message saying that not sufficient
> privilege. I tried a set of privileges which worked on oracle 8.1.6,
> but not
> on oracle 9.2 I memtioned above.
>
>
> What is the privilege needed to be granted or something else needs to
> be done other than just granting privileges?
>
> Thanks in advance.
>
> Ping
Sigh... Roles are *not* active during PL/SQL execution, as mentioned
many times in this ng.
For you to search the archives (or the documentation) for the solution
-- A prosperous 2004, Regards, Frank van BortelReceived on Fri Jan 02 2004 - 10:09:39 CET