Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Accesss to V$ tables to a developer

RE: Accesss to V$ tables to a developer

From: Jeffery Stevenson <jeff_at_mpv.com>
Date: Tue, 11 Jul 2000 10:22:55 -0500
Message-Id: <10555.111674@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_000C_01BFEB21.FA230370 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Accesss to V$ tables to a developerIf 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

------=_NextPart_000_000C_01BFEB21.FA230370 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Accesss to V$ tables to a developer</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D758101115-11072000>If I =
remember=20
correctly, the utlmontr.sql script creates the creates the monitorer = role which=20
has permissions to the V$ tables.&nbsp; I believe this was replaced in = recent=20
versions of Oracle with the SELECT_CATALOG_ROLE which has permissions a = bunch of=20
views (not just the V$ ones)...</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D758101115-11072000>
<P><FONT size=3D2>Jeffery Stevenson<BR>Chief Database Geek<BR>Medical =
Present=20
Value, Inc.<BR>Austin, TX</FONT> </P></SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Uma=20   Sankara_Sivadanam<BR><B>Sent:</B> Tuesday, July 11, 2000 8:28 = AM<BR><B>To:</B>=20
  Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Accesss to V$ = tables=20
  to a developer<BR><BR></DIV></FONT>
  <P><FONT face=3DArial size=3D2>Hello Friends,</FONT> </P>   <P><FONT face=3DArial size=3D2>I am facing an intereting problem at my = office. I=20
  want to give&nbsp; to a perticular developer access to all V$ = tables.What is=20
  the role that i have to grant.He wants access to a view called = v$sqlarea(or=20
  v$sqlbase i don't remember).And he says the DBA has to run a script = called=20
  utlmontr.sql.What is this ?Any idea?</FONT></P><BR>   <P><FONT face=3DArial size=3D2>Thanks in advance</FONT> <BR><FONT = face=3DArial=20
  size=3D2>Uma Shankar</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Tue Jul 11 2000 - 10:22:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US