Question for Audit processes

[greaseman]

I've seen some interesting code and ideas about Audit Trail procedures in this forum, but have one question..... and perhaps I missed it.....

The Audit procedures discussed here seem to circle around adding or changing records. What do you do when it comes to deleting records? How would you go about tracking when a record is deleted, and by who? You know, when the boss comes around, - "I want to know who wiped that information out and when!!"

Any ideas out there?

 

[KenHigg]

I just copy the record over to a archive table before deleting it and tag it with the date and user name in two additional flds.

kh

 

[greaseman]

That sounds doable..... does that cause any increase in size of your database, say if you have a lot of activity to your tables?

Thanks for your response.

 

[KenHigg]

Yes, I would guess an increase in db size would happen. As another measure, I move those 'archived' records out to a cd once a year in one of my db's...

(BTW - The end user management will consider you a hero when they do need this info. )

kh

 

[KenHigg]

Of course one downside to a 'deleted' fld is that if you have a lot of records, etc., performance might become an issue...

kh