From oracle-l-bounce@freelists.org Thu Sep 29 10:50:52 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8TFoqf7004809 for ; Thu, 29 Sep 2005 10:50:52 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8TFok6H004788 for ; Thu, 29 Sep 2005 10:50:46 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C942C1EFCE9; Thu, 29 Sep 2005 10:50:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05073-03; Thu, 29 Sep 2005 10:50:39 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4C37F1EFDC7; Thu, 29 Sep 2005 10:50:39 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=UuxhsWhbCToF25X7iJs0oi5s8+du9sBllttAnG6MTzuMsq+GlOoJnPhvG0ZM469l5mqTR4/Q6J7WBRkK8GeoicYEHkC9QWporYZqVIosgEyfT4sMMEFm9vN5Zab9HxCTKJKZvq2rUGN2ELwsOYFLoqwKqUN1K34ZZSFtJ+QzsbM= Message-ID: <1a36296005092908484a891de2@mail.gmail.com> Date: Thu, 29 Sep 2005 11:48:45 -0400 From: Chirag DBA To: Oracle-L Freelists Subject: Audit MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4487_31240670.1128008925426" X-archive-position: 26106 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chiragdba@gmail.com Precedence: normal Reply-To: chiragdba@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.0 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_4487_31240670.1128008925426 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi , I am trying to do auditing on the DB for the first time. I want to find couple of things but no luck. Column STATEMENT on AUD$, didn give me the meaningful value, where can I find the table for all the listings. I am finding the meaningful values in DBA_AUDIT_TRAIL view. When I do AUDIT DELETE ANY TABLE BY SCOTT; and deleting records from the table, I am getting values as follows. SCOTT SESSION REC 29.09.2005 11:42:24 0 TEMP 208 But I wanna see that deletion occured , I mean anything like ROWS DELETED or like that, possible? Cause if I enable insert,update,delete all three, how will be I differentiate this value SESSION REC? Regards - Chirag ------=_Part_4487_31240670.1128008925426 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hi ,
 
I am trying to do auditing on the DB for the first time.
 
I want to find couple of things but no luck.
 
Column STATEMENT on AUD$, didn give me the meaningful value, where can= I find the table for all the listings.
I am finding the meaningful values in DBA_AUDIT_TRAIL view.
 
When I do AUDIT DELETE ANY TABLE BY SCOTT; and deleting records from t= he table,
I am getting values as follows.
SCOTT      SESSION REC    = ; 29.09.2005 11:42:24         = 0 TEMP           &n= bsp;    208
 
But I wanna see that deletion occured , I mean anything like ROWS DELE= TED or like that, possible?
Cause if I enable insert,update,delete all three, how will be I differ= entiate this value SESSION REC?
 
Regards - Chirag
 
 
------=_Part_4487_31240670.1128008925426-- -- http://www.freelists.org/webpage/oracle-l