RE: Fine Grain Auditing.

From: Subbiah, Stalin <SSubbiah_at_netopia.com>
Date: Tue, 15 Jun 2004 12:35:44 -0700
Message-ID: <F1F84A2E5F9EBD46A9BDB905EB5B10393AA5@mxca1.netopia.com>

I stand corrected. FGA on 10g supports only dml's (insert/update/delete/merge) but not ddl's.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Subbiah, Stalin
Sent: Tuesday, June 15, 2004 12:11 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Patamalla, Chaya
Sent: Tuesday, June 15, 2004 11:58 AM
To: oracle-l_at_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." --

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

Received on Tue Jun 15 2004 - 14:32:58 CDT