CODEWITHSUNDEEP
sybasesap-asevb5
niru dyogi
niru dyogi

Reputation: 639

How to write an audit trail for a table

I am using vb5 and sybase db. I have different roles of people ( with active directory groups), change the tables. I want to write an audit trail (audit table) for this table, to see...all those who changed with time stamp). How to acheive this?

Upvotes: 0

Views: 1637

Answers (2)

Mike Gardner
Mike Gardner

Reputation: 6651

Triggers will work, but depending on the level of granularity and security you need, you may also want to look at using the auditing functionality included in Sybase ASE.

Here is the information on the built in auditing options:

Sybase ASE System Admin Guide: Security Administration - Auditing

Sybase ASE System Admin Guide: Auditing

Upvotes: 1

Sunil Tandon
Sunil Tandon

Reputation: 151

Try the following:

Create a new table with _log (by copying the original table) with an extra column called audit and force inserts/updates into the table with a trigger or by writing an audit procedure. We applied the same logic to dozens of tables in my last company and it served the purpose.

Upvotes: 1

Related Questions