Audit-log

Question

Audit-log

pro

SSC Veteran

Points: 262
More actions
September 29, 2003 at 4:27 am

#160781

Hi All,
I need some idea about the audit-log feature. Is there any other way to do that other than using triggers.
Can anyone throw some light on this.
TIA
kumar

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47794 More actions · Answer 1

Which "audit-log" feature are you referring to?

Another way to implement change logging is to access the database only via stored procedures and have the stored procedures insert change/deleted records into a mirror table.

There are some third-party products around. Take at llok at,

http://www.lockwoodtech.com/index_aa.htm

http://www.lumigent.com/products/entegra/entegra.htm

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

--------------------
Colt 45 - the original point and click interface

pro SSC Veteran Points: 262 More actions · Answer 2

Hi phill,

Thanks for your reply. I am referring to "table level changes" as audit log.

TIA

Kumar

pro SSC Veteran Points: 262 More actions · Answer 3

Hi phill,

Thanks for your reply. I am referring to "table level changes" as audit log.

TIA

Kumar

Dave Green SSC Enthusiast Points: 109 More actions · Answer 4

Why not use a trace, started as a stored proc on system startup?

Dave.

pro SSC Veteran Points: 262 More actions · Answer 5

Hi dave,

My preliminary aim to present the application level user with reports showing tracts the changes to the table(data) and the related user info who did it.

But the trace option in the server collects information more at server level than that could be help to the application user (correct me if i am wrong).

philcart SSC-Forever Points: 47794 More actions · Answer 6

Running a trace will capture as much, or as little, information as you specify. From what SQL statements were sent to the server to the goings on caused by routine tasks such as checkpointing.

It does sound like it would provide more information than you require at the moment. Is it likely that you might need this information at a later stage?

Are you proposing to make the audit information available to end-users, or specifically audit staff? How much development work do you want to perform to implement this?

Here's another couple of third-party tools,

http://www.krell-software.com/OmniAudit/index.htm

http://www.sqlsmartaudit.com/

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

--------------------
Colt 45 - the original point and click interface

pro SSC Veteran Points: 262 More actions · Answer 7

I agree with you. Thanks for your suggestions.

However, i have one doubt about trace. Is it possible to track the changes (old value / new value) done to a particular column (this change might have been caused by a Trigger/ User input/ Programmatic change) for a table.

For e.g.

I want display a report saying

User column changed oldval Newval date Time

"A" "col1" "Test" "Testing" 10/01/03 00:00:00

I anticipate not-longer dev time to implement this.

please give me your valuable inputs.

TIA

Kumar