From: davepylatuk@centurysystems.net   
      
   Hello all, I have a question regarding Oracle9i security.   
      
   I have a database owned by 'admin' all tables in the database are   
   owned and originally created by admin.   
      
   I have a role on this database named: Role1   
      
   If admin creates a new table named: 'new_table' I want another user,   
   say John to be able to GRANT SELECT ON new_table TO Role1;   
      
   This grant does not succeed ? Does anyone know how I can accomplish   
   this.   
      
   Thanks in advance.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)