Re: Grant select on 'sys.dba_*'

conect sys/......
set feed off pagesize 0
spool grtm.sql
select 'GRANT SELECT ON '||object_name||' TO &&username;' WHERE OBJECT_NAME LIKE 'DBA%';
spool off
@grtm
host rm rgtm.sql

    GURON Dominic Lancaster wrote:

> 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 Tue Jun 16 1998 - 01:55:08 CDT