Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> access to v$ and dba tables for user

access to v$ and dba tables for user

From: ton de w <ton_de_winter_at_yahoo.co.uk>
Date: 13 Dec 2006 02:36:57 -0800
Message-ID: <1166006217.664634.9360@j44g2000cwa.googlegroups.com>


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 Received on Wed Dec 13 2006 - 04:36:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US