Re: V$ rights

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 2 Sep 1999 12:56:23 GMT
Message-ID: <37CE73F7.53793AB8@edcmail.cr.usgs.gov>

The SYS user owns the V$ view. In order to grant another user privileges, you must first sign on as the SYS user. But you can't grant select privileges on the V$ view directly. You have to grant on the underlying V_$ view instead. For example to give user SCOTT access to the V$INSTANCE view:

sign on as SYS
issue, GRANT SELECT ON V_$INSTANCE TO SCOTT;

HTH,
Brian

"David F. Newman" wrote:
>
> I have an interesting problem. I have a user who's task
> it is to monitor a database's performance during a load
> test. Without granting DBA to that user, what would be
> the next best thing to allow that user to query the v$
> views?
>
> --
> David F. Newman
> Oracle DBA
> buzzwang_at_ourvillage.com
Received on Thu Sep 02 1999 - 07:56:23 CDT