| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Auditing
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_01C00874.E8E5ADAE
Content-Type: text/plain;
charset="iso-8859-1"
Well, golly be (gotta tone down my swearing)
I thought that you could not audit selects. Wow. I learned something today besides what AFIEDT.BUF really means (or meant). Have you set audit at that level before? It sounds like it would drag a database to a grinding screeching halt, even if you had enough room to keep all those entries in the audit table.
Lisa
Ft. Lauderdale, FL, USA
-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
Sent: Thursday, August 17, 2000 11:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: Auditing
Step one, Set "audit_trail" in the init.ora file to true or DB or OS,
Second,
what do you want to audit? A "audit select on <table_name>" will audit all
selects. There are other options as well.
Dick Goulet
____________________Reply Separator____________________ Author: Siva_Chintalapati <Siva_Chintalapati_at_satyam.com> Date: 8/17/00 4:29 AM
Hello,
can U pl say how to enable auditing on a table.Can U please say the syntax
also .
Regards
Siva
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: Auditing</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hello,</FONT>
<BR><FONT SIZE=2 FACE="Arial">can U pl say how to enable auditing on a
table.Can
U please say the syntax also .</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Regards</FONT>
<BR><FONT SIZE=2 FACE="Arial">Siva</FONT>
</P>
</BODY>
</HTML>
-- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C00874.E8E5ADAE Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Thu Aug 17 2000 - 12:59:30 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: RE: Auditing</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Well, golly be (gotta tone down my swearing)</FONT>
</P>
<P><FONT SIZE=3D2>I thought that you could not audit selects. Wow. I =
learned something today besides what AFIEDT.BUF really means (or = meant). Have you set audit at that level before? It sounds = like it would drag a database to a grinding screeching halt, even if = you had enough room to keep all those entries in the audit = table.</FONT></P>
<P><FONT SIZE=3D2>Lisa</FONT>
<BR><FONT SIZE=3D2>Ft. Lauderdale, FL, USA</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: dgoulet_at_vicr.com [<A =
HREF=3D"mailto:dgoulet_at_vicr.com">mailto:dgoulet_at_vicr.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, August 17, 2000 11:48 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Re:RE: Auditing</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Step one, Set "audit_trail" in the init.ora =
file to true or DB or OS, Second,</FONT>
<BR><FONT SIZE=3D2>what do you want to audit? A "audit =
select on <table_name>" will audit all</FONT>
<BR><FONT SIZE=3D2>selects. There are other options as =
well.</FONT>
</P>
<P><FONT SIZE=3D2>Dick Goulet</FONT>
</P>
<P><FONT SIZE=3D2>____________________Reply =
Separator____________________</FONT>
<BR><FONT SIZE=3D2>Author: Siva_Chintalapati =
<Siva_Chintalapati_at_satyam.com></FONT>
<BR><FONT SIZE=3D2>Date: 8/17/00 =
4:29 AM</FONT>
</P>
<P><FONT SIZE=3D2>Hello,</FONT>
<BR><FONT SIZE=3D2>can U pl say how to enable auditing on a table.Can U =
please say the syntax</FONT>
<BR><FONT SIZE=3D2>also .</FONT>
</P>
<P><FONT SIZE=3D2>Regards</FONT>
<BR><FONT SIZE=3D2>Siva</FONT>
<BR><FONT SIZE=3D2><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML =
3.2//EN"></FONT>
<BR><FONT SIZE=3D2><HTML></FONT>
<BR><FONT SIZE=3D2><HEAD></FONT>
<BR><FONT SIZE=3D2><META HTTP-EQUIV=3D"Content-Type" =
CONTENT=3D"text/html; charset=3Dus-ascii"></FONT>
<BR><FONT SIZE=3D2><META NAME=3D"Generator" =
CONTENT=3D"MS Exchange Server version 5.5.2650.12"></FONT>
<BR><FONT SIZE=3D2><TITLE>RE: Auditing</TITLE></FONT>
<BR><FONT SIZE=3D2></HEAD></FONT>
<BR><FONT SIZE=3D2><BODY></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D2 =
FACE=3D"Arial">Hello,</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D2 =
FACE=3D"Arial">can U pl say how to enable auditing on a = table.Can</FONT>
<BR><FONT SIZE=3D2>U please say the syntax also .</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2><P><FONT SIZE=3D2 =
FACE=3D"Arial">Regards</FONT></FONT>
<BR><FONT SIZE=3D2><BR><FONT SIZE=3D2 =
FACE=3D"Arial">Siva</FONT></FONT>
<BR><FONT SIZE=3D2></P></FONT>
</P>
<P><FONT SIZE=3D2></BODY></FONT>
<BR><FONT SIZE=3D2></HTML></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: </FONT>
<BR><FONT SIZE=3D2> INET: dgoulet_at_vicr.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
 |
 |