From: GK@oblivion.com   
      
   "Ping"  schrieb im Newsbeitrag   
   news:2daccd98.0312101521.794182a4@posting.google.com...   
   > I have sys to grant the following to a schema:   
   >   
   > (login as sys from sqlplus 8.1.6 on linux)   
   >   
   > grant select any table to a;   
   > grant execute on dbms_alert to a;   
   > grant create any procedure to a;   
   >   
   >   
   > when i login as a, i still can NOT do a select on the table   
   > dbms_alert_info ,   
   > it says the table or view does not exist.   
   >   
   > what else do i need to grant to the schema so that i can see the   
   table   
   > from schema a ?   
   >   
   > Thanks in advance!   
   >   
   > Ping   
      
   Qualify the table name with the schema name.   
      
   hth,   
   Guido   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)