From: davepylatuk@centurysystems.net   
      
   Could you clarify please.   
      
   Do you mean the owner must have granted with admin to the role ?   
      
    wrote in message   
   news:a1d154f4.0406040208.676b9ca7@posting.google.com...   
   > "David Pylatuk"  wrote in message   
   news:...   
   > > 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.   
   >   
   > The owner must have GRANTED with ADMIN option.   
   > Note: you are well advised NOT to implement this, because you will get   
   > a myriad of grants, and you may easily loose control.   
   >   
   > Sybrand Bakker   
   > Senior Oracle DBA   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)