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>If I =
remember=20
correctly, the utlmontr.sql script creates the creates the monitorer = role which=20
has permissions to the V$ tables.  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)...</DIV>
<DIV>
Jeffery Stevenson Chief Database Geek Medical =
Present=20
Value, Inc. Austin, TX </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
 <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: root_at_fatcity.com=20 [mailto:root_at_fatcity.com]On Behalf Of Uma=20 Sankara_Sivadanam Sent: Tuesday, July 11, 2000 8:28 = AM To:=20
 Multiple recipients of list ORACLE-L Subject: Accesss to V$ = tables=20
 to a developer </DIV>
 Hello Friends, I am facing an intereting problem at my = office. I=20
 want to give  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? Thanks in advance Uma Shankar </BLOCKQUOTE></BODY></HTML> Received on Tue Jul 11 2000 - 10:22:55 CDT