Also note!!!!

If you decide to implement your own audit, then you need to be aware
that rolling back your transaction will also roll back any additions
that transaction made to your audit log. This may be an issue if you
need to audit attempts at changing / deleting data etc rather than just
successful (committed) transactions.

Adam