sybase - How to write an audit trail for a table -

i using vb5 , sybase db. have different roles of people ( active directory groups), change tables. want write audit trail (audit table) table, see...all changed time stamp). how acheive this?

triggers work, depending on level of granularity , security need, may want @ using auditing functionality included in sybase ase.

here information on built in auditing options:

sybase ase system admin guide: security administration - auditing

sybase ase system admin guide: auditing