| 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: Fine Grain Auditing.
You should be able to use the regular audit feature to audit the creation,
dropping, and altering of objects (example: audit table). We have used this
functionality since at least version 8.1 and I believe it does back much
earlier.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Subbiah, Stalin
Sent: Tuesday, June 15, 2004 3: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." --
 |
 |