Re: Granting access to SQL*DBA monitoring functions

In article <19940901144453.mla_at_132.203.6.11>, mla_at_132.203.6.11 (Michel Lalonde) writes:
> As documented, the script UTLMONTR.SQL should permit access to the
> monitoring functions of SQL*DBA without having to logon as SYS.
> (We have Oracle 7.0.15)
>
> It creates the role MONITORER with the SELECT privileges on the
> V_$... tables.
>
> When I grant this role to user A, he is able to access those tables
> with SQL*Plus. When he connect as A in SQL*DBA he has insufficient
> privileges.
>
> I changed UTLMONTR.SQL to grant the SELECT privileges to PUBLIC.
> User A still has insufficient privileges.
>
> What am I missing ...
>
>
> -----------------------------------------------------------
> Michel Lalonde mlalonde_at_cti.ulaval.ca
> Service de l'informatique
> et telecommunications Tel: (418) 656-3632
> Universite Laval Fax: (418) 656-7305
> Ste-Foy, Quebec, Canada
> G1K 7P4
> -----------------------------------------------------------

-- 
Je ne sais pas.  When I do this under Solaris 2.3, running ORACLE 7.0.15.4, it
works fine. What operating system are you one?

Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285