From: fvanbortel@netscape.net   
      
   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 Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)