Real-time Audit Notification
CentinulNov 24 2010 — edited Nov 25 2010I'm currently running Oracle 11.2.0.1 Enterprise Edition on Windows Server 2003.
I have a requirement to generate notifications when certain audit records are added to the audit trail (audi_trail = db, extended).
Can anyone think of a way to monitor the audit trail in real time? Some initial ideas were the following:
1. AFTER INSERT trigger. Not possible, cannot put a trigger on SYS owned objects.
2. A DBMS_SCHEDULER job that runs periodically and looks at the audit entries added since the last time it ran. While not "real time" it does seem like a practical solution.
The ideal solution for me is using something that is already built into the database, or something that I could develop on my own. Purchasing a product is probably out of the question.
I'm currently only authorized for the Enterprise Edition, not any of the extra cost pack options.
Thanks!