Bruman wrote:
> 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.
SELECT_CATALOG_ROLE does the job, ta!
Curiously granting select on all tables did not give the monitoring app
the required access...
Received on Wed Dec 13 2006 - 12:02:53 CST
