Re: V$ rights

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 3 Sep 1999 20:04:38 GMT
Message-ID: <7qp9km$ric$2@news.seed.net.tw>

David F. Newman <buzzwang_at_churchill.ourvillage.com> wrote in message news:86hfleatdj.fsf_at_churchill.ourvillage.com...

> 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?

In Oracle 8, grant the SELECT_CATALOG_ROLE role. In Oracle 7, create such a role to access v$ views and grant the role, or, grant "select any table" privilege (not recommended). Received on Fri Sep 03 1999 - 15:04:38 CDT