Message-Id: <10555.111757@fatcity.com> From: "MacGregor, Ian A." Date: Tue, 11 Jul 2000 11:49:28 -0700 Subject: RE: Accesss to V$ tables to a developer This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --Boundary_(ID_sHPJQS55j2MCi4woOYUpxg) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT Be aware that the program field of the v$session table may contain users' passwords. Ian MacGregor Stanford Linear Accelerator Center ian@slac.stanford.edu -----Original Message----- From: Jeffery Stevenson [mailto:jeff@mpv.com] Sent: Tuesday, July 11, 2000 9:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Accesss to V$ tables to a developer If I remember correctly, the utlmontr.sql script creates the creates the monitorer role which has permissions to the V$ tables. I believe this was replaced in recent versions of Oracle with the SELECT_CATALOG_ROLE which has permissions a bunch of views (not just the V$ ones)... Jeffery Stevenson Chief Database Geek Medical Present Value, Inc. Austin, TX -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Uma Sankara_Sivadanam Sent: Tuesday, July 11, 2000 8:28 AM To: Multiple recipients of list ORACLE-L Subject: Accesss to V$ tables to a developer Hello Friends, I am facing an intereting problem at my office. I want to give to a perticular developer access to all V$ tables.What is the role that i have to grant.He wants access to a view called v$sqlarea(or v$sqlbase i don't remember).And he says the DBA has to run a script called utlmontr.sql.What is this ?Any idea? Thanks in advance Uma Shankar --Boundary_(ID_sHPJQS55j2MCi4woOYUpxg) Content-type: text/html; charset=iso-8859-1 Content-transfer-encoding: 7BIT Accesss to V$ tables to a developer
Be aware that the program field of the v$session table may contain users' passwords.
 
Ian MacGregor
Stanford Linear Accelerator Center
ian@slac.stanford.edu
 
-----Original Message-----
From: Jeffery Stevenson [mailto:jeff@mpv.com]
Sent: Tuesday, July 11, 2000 9:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Accesss to V$ tables to a developer

If I remember correctly, the utlmontr.sql script creates the creates the monitorer role which has permissions to the V$ tables.  I believe this was replaced in recent versions of Oracle with the SELECT_CATALOG_ROLE which has permissions a bunch of views (not just the V$ ones)...

Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Uma Sankara_Sivadanam
Sent: Tuesday, July 11, 2000 8:28 AM
To: Multiple recipients of list ORACLE-L
Subject: Accesss to V$ tables to a developer

Hello Friends,

I am facing an intereting problem at my office. I want to give  to a perticular developer access to all V$ tables.What is the role that i have to grant.He wants access to a view called v$sqlarea(or v$sqlbase i don't remember).And he says the DBA has to run a script called utlmontr.sql.What is this ?Any idea?


Thanks in advance
Uma Shankar