Either grant directly on the underlying objects as SYbrand suggests which
gives you complete control or
grant select_catalog_role to <user>; will work for you.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:gkruguof2ekopojfvrhka4jpc2bqejac4h_at_4ax.com...
> On Tue, 18 Jun 2002 16:35:20 GMT, "Scott W"
> <CantGiveMyAddressBecauseIm_at_work.com> wrote:
>
> >Does a user have to have dba privs to access such system views as
V$OPTION,
> >V$PARAMETER, and V$VERSION ? You cannot grant selects on them since they
> >are not fixed. The only other way I know of is through the SELECT ANY
> >TABLE. I have a customer who doesn't like any of this (doesn't want to
> >grant DBA or SELET ANY TABLE) so I am looking for any other way for a
> >non-DBA to access these views.
> >
> >TIA, Scott
> >
> >
> >
>
>
> You need to use V_$OPTION, V_$PARAMETER and V_$VERSION. The rest are
> synonyms.
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Jun 19 2002 - 04:08:46 CDT
