Re: access to v$ and dba tables for user

On Dec 13, 5:46 am, "sybrandb" <sybra..._at_gmail.com> wrote:
> 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
>
> > Tongrant 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

Way old indeed. Ton, create a role and issue a grant on the specific v$ views and dba_* views needed by the third-paty monitoring tool then grant this role to the tool ID.

Never grant an unnecessary privilege to any user.

HTH -- Mark D Powell -- Received on Wed Dec 13 2006 - 07:41:22 CST