How can a 'non-owner' grant access to a table.
From: David Pylatuk <davepylatuk_at_centurysystems.net>
Date: Thu, 3 Jun 2004 09:11:24 -0400
Message-ID: <FoFvc.31264$Hn.1016242_at_news20.bellglobal.com>
Hello all, I have a question regarding Oracle9i security.
Date: Thu, 3 Jun 2004 09:11:24 -0400
Message-ID: <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. Received on Thu Jun 03 2004 - 15:11:24 CEST