From oracle-l-bounce@freelists.org Tue Jun 15 14:08:20 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5FJ7sj18517 for ; Tue, 15 Jun 2004 14:08:04 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5FJ7Y618438 for ; Tue, 15 Jun 2004 14:07:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DB41272C747; Tue, 15 Jun 2004 13:52:03 -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 07647-27; Tue, 15 Jun 2004 13:52:03 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2CA4072C2C3; Tue, 15 Jun 2004 13:52:03 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 15 Jun 2004 13:50:40 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A1D9672C47D for ; Tue, 15 Jun 2004 13: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 06291-92 for ; Tue, 15 Jun 2004 13:50:39 -0500 (EST) Received: from mxca1.netopia.com (host222.netopia.com [65.206.239.222]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B63572C473 for ; Tue, 15 Jun 2004 13:50:39 -0500 (EST) Received: by mxca1.netopia.com with Internet Mail Service (5.5.2657.72) id ; Tue, 15 Jun 2004 12:10:58 -0700 Message-ID: From: "Subbiah, Stalin" To: "'oracle-l@freelists.org'" Subject: RE: Fine Grain Auditing. Date: Tue, 15 Jun 2004 12:10:58 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4530C.7D59F90B" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2785 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: SSubbiah@netopia.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------_=_NextPart_001_01C4530C.7D59F90B Content-Type: text/plain Hi, I haven't gauged the performance overhead of using FGA, but it's works like a charm. I'll let others to comment on performance overhead of using it. As far as auditing DDL's, you need to get to 10g (i assume your using 9i) which supports auditing select as well DDL's. -Stalin _____ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Patamalla, Chaya Sent: Tuesday, June 15, 2004 11:58 AM To: oracle-l@freelists.org Subject: Fine Grain Auditing. Has any one worked with Oracle's Fine Grain Auditing. What is the performance overhead. Also, has anyone asked for auditing DDL? We are getting requirements about auditing DDL functionality. Thanks Chaya Patamalla I/T Sr.Database Administrator --"The opinions expressed herein are solely the author's and are not necessarily the opinion of USAA." -- ------_=_NextPart_001_01C4530C.7D59F90B Content-Type: text/html Fine Grain Auditing.
Hi,
 
I haven't gauged the performance overhead of using FGA, but it's works like a charm. I'll let others to comment on performance overhead of using it.
 
As far as auditing DDL's, you need to get to 10g (i assume your using 9i) which supports auditing select as well DDL's.
 
-Stalin


From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Patamalla, Chaya
Sent: Tuesday, June 15, 2004 11:58 AM
To: oracle-l@freelists.org
Subject: Fine Grain Auditing.


Has any one worked with Oracle's Fine Grain Auditing.

What is the performance overhead.

Also, has anyone asked for auditing DDL?  We are getting requirements about auditing  DDL functionality.


Thanks

Chaya Patamalla
I/T Sr.Database Administrator

 

--"The opinions expressed herein are solely the author's and are not necessarily the opinion of USAA." --         

------_=_NextPart_001_01C4530C.7D59F90B-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------