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