{"id":323,"date":"2011-02-02T00:09:48","date_gmt":"2011-02-02T00:09:48","guid":{"rendered":"http:\/\/www.oradba.ch\/?p=323"},"modified":"2011-05-31T16:00:12","modified_gmt":"2011-05-31T14:00:12","slug":"manage-audit-trails-with-dbms_audit_mgmt","status":"publish","type":"post","link":"https:\/\/www.oradba.ch\/wordpress\/2011\/02\/manage-audit-trails-with-dbms_audit_mgmt\/","title":{"rendered":"Manage Audit Trails with DBMS_AUDIT_MGMT"},"content":{"rendered":"

I’ve recently wrote an DOAG article about Managing Audit Trails with dbms_audit_mgmt, which has been officially introduced in Oracle 11g R2. The same article will also be in the upcoming SOUG newsletter. The article itself is written in german and is also available on this side in the publication section (\"\" Audit Management mit DBMS_AUDIT_MGMT.pdf<\/a>)<\/p>\n

dbms_audit_mgmt<\/i> has been officially released as a 11g R2 feature. For earlier releases there is a patch available or it is part of a patchset (10.2.0.5, 11.1.0.7). More information to the availability of this package can be found in the Metalink Note New Feature DBMS_AUDIT_MGMT To Manage And Purge Audit Information [731908.1]<\/a><\/i>. <\/p>\n

In the article I’ve mentioned the licensing, but could not provide a clear statement. In the meantime I’ve been in contact with Oracle to bring a bit of light into the licensing situation (ok just for dbms_audit_mgmt<\/i> not for the whole oracle licensing \ud83d\ude09 ). As mentioned in the Metalink Note [731908.1]<\/a> it is mandatory to have a valid Oracle Audit Vault license when using this package in any versions before 11.2. Starting with 11.2 the dbms_audit_mgmt<\/i> package is part of the regular release and can be used in the Standard and Enterprise Edition without further licensing.<\/p>\n

The official feedback:<\/p>\n

\u2026 I now have some further feedback from the audit development team, and can confirm this package is available with SE and EE starting with 11.2. No further license is required.<\/p><\/blockquote>\n

As soon as the remaining bugs are fixed (see Current issues Known Issues When Using: DBMS_AUDIT_MGMT [804624.1]<\/a><\/i> we have a nice and smooth way to handle the audit trails. I’ll probably post a few ideas and examples in one of my next posts.<\/p>\n","protected":false},"excerpt":{"rendered":"

I’ve recently wrote an DOAG article about Managing Audit Trails with dbms_audit_mgmt, which has been officially introduced in Oracle 11g R2. This blog post is just to link the article and provides a few more information. <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[7,8,13,5,11],"tags":[18],"class_list":["post-323","post","type-post","status-publish","format-standard","hentry","category-11gr1","category-11gr2","category-audit","category-oracle-database","category-security","tag-trivadiscontent"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1aErb-5d","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":230,"url":"https:\/\/www.oradba.ch\/wordpress\/2010\/01\/managing-audit-trails\/","url_meta":{"origin":323,"position":0},"title":"Managing Audit Trails","author":"Stefan","date":"1. January 2010","format":false,"excerpt":"I've screwed up somehow this post and created a new one Manage Audit Trails with DBMS_AUDIT_MGMT. This is mini post is just to make sure that an already published permalink does not points to \/dev\/null...","rel":"","context":"In "10gR2"","block_context":{"text":"10gR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/10gr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":354,"url":"https:\/\/www.oradba.ch\/wordpress\/2011\/03\/soug-presentation-on-dbms_audit_mgmt\/","url_meta":{"origin":323,"position":1},"title":"SOUG Presentation on DBMS_AUDIT_MGMT","author":"Stefan","date":"9. March 2011","format":false,"excerpt":"On the 24 of March I'll have a presentation on Database Audit and DBMS_AUDIT_MGMT at the SOUG SIG Event. The presentation is about 30 minutes and will cover a rough overview of DBMS_AUDIT_MGMT, latest Issues and Bugs as well some Ideas on how audit could be simplified. Have a look\u2026","rel":"","context":"In "11gR2"","block_context":{"text":"11gR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/11gr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3240,"url":"https:\/\/www.oradba.ch\/wordpress\/2019\/09\/audit-trail-cleanup-in-oracle-multitenant-environments\/","url_meta":{"origin":323,"position":2},"title":"Audit Trail cleanup in Oracle Multitenant environments","author":"Stefan","date":"20. September 2019","format":false,"excerpt":"A crucial aspect of any database audit concept is the management and maintenance of audit trails. Depending on the defined audit policies and the database activity, an audit trail can grow relatively quickly. Oracle Multitenant environments increase the operational effort because the root container and each PDB uses their own\u2026","rel":"","context":"In "12R2"","block_context":{"text":"12R2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/12r2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":410,"url":"https:\/\/www.oradba.ch\/wordpress\/2011\/03\/slides-soug-presentation-on-dbms_audit_mgmt\/","url_meta":{"origin":323,"position":3},"title":"Slides SOUG Presentation on DBMS_AUDIT_MGMT","author":"Stefan","date":"24. March 2011","format":false,"excerpt":"Just finished my presentation about audit management with DBMS_AUDIT_MGMT at the SOUG Special Interest Group Event in Baden. I'm glad having a MIFI so I can immediately upload the slides :-) and still have some time for the aperitif.... I'm happy for any comment on the presentation or the slides.\u2026","rel":"","context":"In "Audit"","block_context":{"text":"Audit","link":"https:\/\/www.oradba.ch\/wordpress\/category\/audit\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1019,"url":"https:\/\/www.oradba.ch\/wordpress\/2013\/05\/use-of-default_cleanup_interval\/","url_meta":{"origin":323,"position":4},"title":"Use of DEFAULT_CLEANUP_INTERVAL","author":"Stefan","date":"16. May 2013","format":false,"excerpt":"Following a question to the blog post\u00a0Database Audit and Audit trail purging, I noticed something interesting about the DEFAULT_CLEANUP_INTERVAL parameter. On one hand, it is mandatory to initialize the audit trail and to define a DEFAULT_CLEANUP_INTERVAL, on the other hand, the parameter is not used at all. Oracle explains this\u2026","rel":"","context":"In "11gR2"","block_context":{"text":"11gR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/11gr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":527,"url":"https:\/\/www.oradba.ch\/wordpress\/2011\/05\/database-audit-and-audit-trail-purging\/","url_meta":{"origin":323,"position":5},"title":"Database Audit and Audit trail purging","author":"Stefan","date":"30. May 2011","format":false,"excerpt":"Setting up database audit is fairly easy. Since the availability of DBMS_AUDIT_MGMT the housekeeping of the audit trail is just a trifle. After the introduction of DBMS_AUDIT_MGMT in an post early this February, I would like to take a closer look at the housekeeping of the Audit Trail and provide\u2026","rel":"","context":"In "10gR2"","block_context":{"text":"10gR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/10gr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/comments?post=323"}],"version-history":[{"count":3,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/323\/revisions"}],"predecessor-version":[{"id":573,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/323\/revisions\/573"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/categories?post=323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/tags?post=323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}