Re: Accesss to V$ tables to a developer

From: Ram <ramg_at_quaartz.com>
Date: Thu, 13 Jul 2000 14:06:36 -0700
Message-Id: <10557.112006@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_031A_01BFECD3.8EECC740 Content-Type: text/plain;

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

Accesss to V$ tables to a developerTry creating a view on the necessary = 'V$' table and grant access to the view to him.

Original Message -----=20 From: Nikolay Kumanov=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, July 11, 2000 9:05 AM Subject: RE: Accesss to V$ tables to a developer

  A quick and dirty solution in 8.x will be to grant the = SELECT_CATALOG_ROLE, although this will give him/her access to many = objects.
  =20
  IMHO, better solution is to use a heavy, blunt and cheap object as it = must be done to developers that ask for admittance to the holy DBA land.

Dr. Nikolay Kumanov=20

MIS Manager, Zeitungsgruppe Bulgarien GmbH=20 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria=20 phone: +(359-2)4339-643, fax: +(359-2)946-1286=20 mailto:nkumanov_at_zgb.bg=20

"Show me a completely smooth operation and I'll show you someone who's =

covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: = Dune"=20

-----Original Message-----
From: Uma Sankara_Sivadanam [mailto:UmaSankara_Sivadanam_at_satyam.com] Sent: Tuesday, July 11, 2000 4:28 PM To: Multiple recipients of list ORACLE-L Subject: Accesss to V$ tables to a developer

Hello Friends,=20

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=20
Uma Shankar=20

------=_NextPart_000_031A_01BFECD3.8EECC740 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.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Try creating a view on the necessary =
'V$' =20
table and grant access to the view to him.</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:nkumanov_at_zgb.bg" title=3Dnkumanov_at_zgb.bg>Nikolay = Kumanov</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, July 11, 2000 = 9:05=20
AM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Accesss to V$ = tables to a=20
  developer</DIV>
  <DIV><BR></DIV>
  <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN = class=3D093172714-11072000>A=20
  quick and dirty solution in 8.x will be to grant the = SELECT_CATALOG_ROLE,=20
  although this will give him/her access to many = objects.</SPAN></FONT></DIV>
  <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20   class=3D093172714-11072000></SPAN></FONT> </DIV>   <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20   class=3D093172714-11072000>IMHO, better solution is to use a heavy, = blunt and=20
  cheap object as it must be done to developers that ask for admittance = to the=20
  holy DBA land.</SPAN></FONT></DIV>

  <DIV>&nbsp;</DIV>
  <P><FONT face=3DArial size=3D2>Dr. Nikolay Kumanov</FONT> </P>
  <P><FONT face=3DArial size=3D2>MIS Manager, Zeitungsgruppe Bulgarien =

GmbH</FONT>=20
<BR><FONT face=3DArial size=3D2>47, Tsarigradsko chaussee, Sofia 1504, =

  Bulgaria</FONT> <BR><FONT face=3DArial size=3D2>phone: = +(359-2)4339-643, fax:=20
  +(359-2)946-1286</FONT> <BR><U><FONT color=3D#0000ff face=3DArial = size=3D2><A=20
  href=3D"mailto:nkumanov_at_zgb.bg">mailto:nkumanov_at_zgb.bg</A></FONT></U> =
</P>

  <P><FONT face=3DArial size=3D2>"Show me a completely smooth operation = and I'll=20
  show you someone who's</FONT> <BR><FONT face=3DArial size=3D2>covering = mistakes.=20
  Real boats rock." - Frank Herbert, "Chapterhouse: Dune"</FONT> </P>   <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> Uma = Sankara_Sivadanam=20

[mailto:UmaSankara_Sivadanam_at_satyam.com]<BR><B>Sent:</B> Tuesday, = July 11,=20

2000 4:28 PM<BR><B>To:</B> Multiple recipients of list=20 ORACLE-L<BR><B>Subject:</B> Accesss to V$ tables to a=20 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  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 = Received on Thu Jul 13 2000 - 16:06:36 CDT