Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Grant select on 'sys.dba_*'
TIA,
I don't know if you know this but just in case,
You can run the scripts catdbsyn.sql from $ORACLE_HOME/rdbms/admin. You have to run this scripts under the user account which needs the access to the dba_* views.
From oracle 7.3 there is no need to run this script. All user have default access to this views.
Regards,
Alfons Riesebeek
Guron <guron_at_hotmail.com> schrijfbewerkingen: > 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 - 02:47:38 CDT