How to do auditing for fDML
From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Sat, 19 Dec 2009 21:33:39 -0800 (PST)
Message-ID: <150ed881-b83b-4a49-bf68-9a3f64b2312a_at_r5g2000yqb.googlegroups.com>
I want to monitor if system accounts such as system, sys or other DBA accounts
did any DML in my application schema. What are the minimal audit statements
needed to accomplish this. I did read Oracle's documentation on AUDIT statement, but it
doest not show how to audit entire schema, it shows how to audit indivual objects in a schema which requires lots of staements and when new bjects are added, one has to add auditing on them.
Date: Sat, 19 Dec 2009 21:33:39 -0800 (PST)
Message-ID: <150ed881-b83b-4a49-bf68-9a3f64b2312a_at_r5g2000yqb.googlegroups.com>
I want to monitor if system accounts such as system, sys or other DBA accounts
did any DML in my application schema. What are the minimal audit statements
needed to accomplish this. I did read Oracle's documentation on AUDIT statement, but it
doest not show how to audit entire schema, it shows how to audit indivual objects in a schema which requires lots of staements and when new bjects are added, one has to add auditing on them.
I know using Oracle Database Vault one can set realm to restrict this
but I do
not have Data Vault, just looking to audit this using Oracle’s
database auditing.
My organization also has Oracle Audit Vault, but Database Auditing
Events have to be set in database
first for collection agent to pass this information to Oracle Audit
Vault server.
Thanks a lot.
Received on Sat Dec 19 2009 - 23:33:39 CST