Home -> Usenet -> comp.databases.oracle -> Granting access to SQL*DBA monitoring functions

Granting access to SQL*DBA monitoring functions

From: Michel Lalonde <mla_at_132.203.6.11>
Date: Thu, 1 Sep 1994 18:44:00 GMT
Message-ID: <19940901144453.mla_at_132.203.6.11> 






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


Received on Thu Sep 01 1994 - 20:44:00 CEST












Original text of this message