Re: access to v$ and dba tables for user

From: Bruman <uv_katastrophe_at_yahoo.com>
Date: 13 Dec 2006 05:47:30 -0800
Message-ID: <1166017650.795869.163180@80g2000cwy.googlegroups.com>

ton de w wrote:
> Hello,
>
> Would like to grant select on v$ and dba tables, (for a 3rd party
> monitoring tool) on Oracle 9.2.
> Seem to remember doing this with a previous version with utlmntr.sql in
> the admin dir.
> But it is not there in 9.2. Must/Should I get a list of v$ and dba
> tables and grant select on each table? Or is a there a better way?
>
> TIA
>
> Ton

Grant SELECT_CATALOG_ROLE to the user for V$ and DBA views. My DBA gave me this role in the development instance only. Received on Wed Dec 13 2006 - 07:47:30 CST