Re: access to v$ and dba tables for user

On Dec 13, 11:36 am, "ton de w" <ton_de_win..._at_yahoo.co.uk> 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 <user>
Generally speaking though this is a bad idea, as it will provide way too much access.
You may be better off implementing this by addressing the ora-942's. (So called 'Knijp en piep' system)

IIRC the script you mention was specifically for the monitor in svrmgrm (so way old)

-- 
Sybrand Bakker
Senior Oracle DBA