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.

grant select on tablename to john with grant option;

then, John could
grant select on tablename to role1;


"David Pylatuk" <davepylatuk (AT) centurysystems (DOT) net> wrote

Admin has to do:
GRANT SELECT ON new_table TO John WITH GRANT OPTION

Hilarion

Thanks for the response.

However, I am using roles to handle table security and not granting table
permissions directly to tables but to roles.

The WITH GRANT OPTION does not work for roles. Any other ideas ?

Thanks again.

"Hilarion" <hilarion (AT) SPAM (DOT) op.SMIECI.pl> wrote