RE: AUDIT question
Date: Thu, 10 Nov 2011 18:57:05 +0000
Do you really need to audit DBA users? What about auditing actions such as audit table, audit view, audit procedure, etc ... so all create table, alter table, and drop table etc... have an audit record created for the action.
You can also turn auditing on for user SYS activities.
Between the two features above you get a manageable but pretty decent record of DDL actions.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bill Zakrzewski Sent: Thursday, November 10, 2011 10:17 AM To: oracle-l_at_freelists.org L
Subject: AUDIT question
We would like to audit all activities of the oracle users that have the DBA role granted. My initial thought was to create a logon trigger to check for the DBA role and turn auditing on for that particular session, but I do not believe that is an option. Any ideas?
http://www.freelists.org/webpage/oracle-l Received on Thu Nov 10 2011 - 12:57:05 CST