home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,473 of 2,288   
   David Pylatuk to sybrandb@yahoo.com   
   Re: How can a 'non-owner' grant access t   
   04 Jun 04 08:20:20   
   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca