From: forbrich@yahoo.net   
      
   Ping wrote:   
   >   
   > Sorry, some modification to the problem description: the T1 in fact is   
   > a view and T1's base tables are all owned by sys. The T1 is   
   > successfully compiled in U1's schema.   
   >   
   > U2 has 'create procedure' privilege granted in addition to some other   
   > privileges.   
   >   
   > I also have U1 granted select specifically to U2, still got same error   
   > message as below when compiled:   
   >   
   > PL/SQL: Declaration ignored   
   > PLS-00904: insufficient privilege to access object U1.T1   
   >   
   > Any thoughts and help would be appreciated.   
      
   I'm still wondering whether U2 can do a plain and simple 'SELECT   
   COUNT(*) FROM U1.T1' and 'SELECT COUNT(*) FROM S1' in SQL*Plus.   
      
   I wouldn't even worry about the PL/SQL part of it until the basic access   
   for the SELECT is set up properly.   
      
   /Hans   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)