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

Could you clarify please.

Do you mean the owner must have granted with admin to the role ?

<sybrandb_at_yahoo.com> wrote in message news:a1d154f4.0406040208.676b9ca7_at_posting.google.com...
> "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 - 14:20:20 CEST