RE: Accesss to V$ tables to a developer

From: Nikolay Kumanov <nkumanov_at_zgb.bg>
Date: Tue, 11 Jul 2000 17:31:35 +0300
Message-Id: <10555.111668@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.

------_=_NextPart_001_01BFEB44.B746D7C0
Content-Type: text/plain;

charset="iso-8859-1"

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.

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

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

"Show me a completely smooth operation and I'll show you someone who's covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune"

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

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_001_01BFEB44.B746D7C0
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//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 5.00.3018.900" name=GENERATOR></HEAD>
<BODY>
<DIV>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.</DIV>
<DIV><SPAN
class=093172714-11072000> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
Dr. Nikolay Kumanov 
MIS Manager, Zeitungsgruppe Bulgarien GmbH
 47, Tsarigradsko chaussee, Sofia 1504,
Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 <A href="mailto:nkumanov_at_zgb.bg">mailto:nkumanov_at_zgb.bg</A> 
"Show me a completely smooth operation and I'll show
you someone who's covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune" 
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV align=left class=OutlookMessageHeader dir=ltr>-----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 </DIV>
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 </BLOCKQUOTE></BODY></HTML> Received on Tue Jul 11 2000 - 09:31:35 CDT