Re: Grant select on all tables of other user

Matthias Hoys wrote:

> A developer asked me this question :
> Is it possible to create a user (a read-only user) which has by default
> SELECT rights on all tables of another user ? So something like the SELECT
> ANY TABLE privilege but restricted to only one schema.
>
> Any ideas ? Db is Oracle 9.2.0.5.0.

CREATE USER readonly
IDENTIFIED BY readonly
TEMPORARY TABLESPACE temp
QUOTA 0 ON system;

GRANT create session TO readonly;

GRANT select ON <schema_name.table_name_1> TO readonly;
GRANT select ON <schema_name.table_name_2> TO readonly;
GRANT select ON <schema_name.table_name_n> TO readonly;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)