Re: What are the minimum privs needed to acces V$VERSION, OPTION, PARAMETER ?

Home -> Community -> Usenet -> c.d.o.misc -> Re: What are the minimum privs needed to acces V$VERSION, OPTION, PARAMETER ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 18 Jun 2002 19:32:38 +0200
Message-ID: <gkruguof2ekopojfvrhka4jpc2bqejac4h@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 Tue Jun 18 2002 - 12:32:38 CDT