RE: Accesss to V$ tables to a developer

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Tue, 11 Jul 2000 11:49:28 -0700
Message-Id: <10555.111757@fatcity.com>

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_at_slac.stanford.edu <mailto:ian_at_slac.stanford.edu>

-----Original Message-----
From: Jeffery Stevenson [mailto:jeff_at_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_at_fatcity.com [mailto:root_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<TITLE>Accesss to V$ tables to a developer</TITLE>
<META content='"MSHTML 4.72.3713.2800"' name=GENERATOR>
</HEAD>
<BODY>
<DIV><SPAN class=671535517-11072000><FONT color=#000000 face=Arial size=2>Be
aware that the program field of the v$session table may contain users' passwords.</FONT></SPAN></DIV>
<DIV><SPAN class=671535517-11072000><FONT color=#000000 face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=671535517-11072000><FONT color=#000000 face=Arial size=2>Ian
MacGregor</FONT></SPAN></DIV>
<DIV><SPAN class=671535517-11072000><FONT color=#000000 face=Arial
size=2></FONT></SPAN><SPAN class=671535517-11072000><FONT color=#000000 face=Arial size=2>Stanford Linear Accelerator Center</FONT></SPAN></DIV>
<DIV><SPAN class=671535517-11072000><FONT color=#000000 face=Arial

size=2></FONT></SPAN><SPAN class=671535517-11072000><FONT color=#000000 
face=Arial size=2><A 
href="mailto:ian_at_slac.stanford.edu">ian_at_slac.stanford.edu</A></FONT></SPAN></DIV>

<DIV> </DIV>
<BLOCKQUOTE>

<DIV align=left class=OutlookMessageHeader DIR = LTR><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Jeffery Stevenson [mailto:jeff_at_mpv.com]<BR><B>Sent:</B> Tuesday, July 11, 2000 9:24 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Accesss to V$ tables to a developer<BR><BR></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=758101115-11072000>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)...</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=758101115-11072000> <P><FONT size=2>Jeffery Stevenson<BR>Chief Database Geek<BR>Medical Present Value, Inc.<BR>Austin, TX</FONT> </P></SPAN></FONT></DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px">

        <DIV align=left class=OutlookMessageHeader dir = ltr><FONT face=Tahoma 
        size=2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com 
        [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Uma 
        Sankara_Sivadanam<BR><B>Sent:</B> Tuesday, July 11, 2000 8:28 
        AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> 
        Accesss to V$ tables to a developer<BR><BR></DIV></FONT>
        <P><FONT face=Arial size=2>Hello Friends,</FONT> </P>
        <P><FONT face=Arial size=2>I am facing an intereting problem at my 
        office. I want to give&nbsp; 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?</FONT></P><BR>
        <P><FONT face=Arial size=2>Thanks in advance</FONT> <BR><FONT face=Arial 
        size=2>Uma Shankar</FONT> </P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

Received on Tue Jul 11 2000 - 13:49:28 CDT