Re:RE: Accesss to V$ tables to a developer

From: <dgoulet_at_vicr.com>
Date: Wed, 12 Jul 2000 09:00:15 -0400
Message-Id: <10556.111795@fatcity.com>

The last time I had a developer ask for that type of access, he proved to be the biggest pain in the &^% that's ever come around. His access lasted for about 2 days before it got pulled. Seems he had more ideas on how I should do my job to make his easier than the moon has craters.

Dick Goulet

____________________Reply Separator____________________

Subject: RE: Accesss to V$ tables to a developer Author: "MacGregor; Ian A." <ian_at_SLAC.Stanford.EDU> Date: 7/11/00 10:34 PM

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-----
Sent: Tuesday, July 11, 2000 9:24 AM
To: Multiple recipients of list ORACLE-L

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-----
Sankara_Sivadanam
Sent: Tuesday, July 11, 2000 8:28 AM
To: Multiple recipients of list ORACLE-L

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

<!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

Received on Wed Jul 12 2000 - 08:00:15 CDT