The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Similar to http://sqlanywhere-forum.sap.com/questions/8559/retrieve-audit-ddl-from-the-graphic-auditing-tab-in-sybase-central-for-11012427

We're looking for a 3rd party tool to extend the native auditing functionality to allow reporting on historical data per DIACAP V-6173 of the AS&D Checklist to retain logs for 5 years.

Or has someone enabled the functionality of ASE to log audit data to an audit DB?

Only tool I found stopped supporting SQLA at v10, and I'm getting errors with v16 https://www.softtreetech.com/dbaudit/

asked 27 Feb '14, 12:08

vorear2's gravatar image

vorear2
1067713
accept rate: 0%

edited 27 Feb '14, 12:11

1

Good news, the latest version of DBAUDIT works with Sybase ASA v16, bad news I haven't received any responses from this post about alternatives. I found Breck Carter's series on creating our own auditing functionality which we might consider http://sqlanywhere.blogspot.com/2008/02/tip-triggering-audit-trail.html

(04 Mar '14, 12:09) vorear2
1

I'm having an EXTREME case of deja vu here... but no, there is no other recent question on the same subject. It must be this one I am thinking of: Auditing group membership

Good luck! ...if you really do have to comply with Sarbanes-Oxley, you will need it. If Dodd-Frank is also in your future, prayer is recommended :)

(05 Mar '14, 09:14) Breck Carter

Thanks, love your blog but we're trying to meet DOD http://www.stigviewer.com/check/V-32376

(05 Mar '14, 11:35) vorear2
Replies hidden

A delightfully vague document :)

Seriously, that would be a fun project: Build an audit trail framework for SQL Anywhere. The base data would be ACID-protected by storing it in the database itself, and MobiLink could be used to continuously copy it upwards/outwards to another SQL Anywhere database, likewise ACID-protected but stored elsewhere. Marketers could write glowing descriptions of how thorough and perfectly paranoid such a mechanism would be. One might even be able to write a blog post about it... after spending hundreds (hah!) of hours building it. (Yes, I have just watched Almost Human episode 10 in which a futuristic pharmaceutical printer wrote a perfect audit trail of the drugs it created to "the cloud" even while being hacked by an evil-doer :)

(05 Mar '14, 13:55) Breck Carter
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×5

question asked: 27 Feb '14, 12:08

question was seen: 459 times

last updated: 05 Mar '14, 14:05