RE: audit reports
- From: "Blanchard William" <William.Blanchard@xxxxxxxxxx>
- To: <joseph.armstrong-champ@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 Apr 2008 11:57:46 -0500
I see two options. 1. I would create an oracle file (link to os file)
and then create triggers to monitor ddl and anyone that logs on with
sysdba privs. 2. You could use fga and then run your reports off of the
fga table. Personally, I would go with fga because you will have a
record in the database and can format your report however you want
(Crystal Reports, CSV, etc.).
William
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Armstrong-Champ
Sent: Wednesday, April 09, 2008 10:50 AM
To: ORACLE-L
Subject: audit reports
We will be auditing sysdba privs as well as ddl statements by certain
users. Audit files for sysdba will be written to os files and ddl
auditing will be written to the database. Does anyone know of any
programs we can run on any of the above audit data that we can use to
run reports?
Thanks.
Joe
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
