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

[David Pylatuk]

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.

[sybrandb]

"David Pylatuk" <da*********@centurysystems.net> wrote in message news:<Fo********************@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

[David Pylatuk]

Could you clarify please.

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

<sy******@yahoo.com> wrote in message
news:a1**************************@posting.google.c om...

"David Pylatuk" <da*********@centurysystems.net> wrote in message

news:<Fo********************@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

[sybrandb]

"David Pylatuk" <da*********@centurysystems.net> wrote in message news:<MK********************@news20.bellglobal.com >...

Could you clarify please.

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

Yes, I did mean that. Otherwise, no joy, unless you are on 9i and use
SYS to bypass security. Grants made by SYS, however, are not exported
in a logical dump, as SYS is not exported

Sybrand Bakker
Senior Oracle DBA