Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Real-time Audit Notification

CentinulNov 24 2010 — edited Nov 25 2010
I'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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2010
Added on Nov 24 2010
5 comments
467 views