Re: How can a 'non-owner' grant access to a table.

"David Pylatuk" <davepylatuk_at_centurysystems.net> wrote in message news:<FoFvc.31264$Hn.1016242_at_news20.bellglobal.com>...
> 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 Received on Fri Jun 04 2004 - 12:08:49 CEST