Re: Grant select on 'sys.dba_*'

You could create a script by spooling to a file. Such as:

spool grantdba.sql

select 'GRANT SELECT ON '||table_name||' TO USER;' from dba_tables
where table_name like 'DBA%';

spool off

Dominic Lancaster <dominic_at_bimberi.com.au> wrote in article <35811416.2DD6_at_bimberi.com.au>...
> Could someone please help me grant what is essetially
> read only access for a user to the 'sys.dba_*' tables,
> I was thinking of:
> GRANT SELECT ON TABLE like 'sys.dba%' TO USER;
>
> Would this work?
>
> TIA
>
Received on Fri Jun 12 1998 - 18:26:31 CDT