An Auditing Slution with XML And XSL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David McKinney » An Auditing Slution with XML And XSL

An Auditing Slution with XML And XSL

Rate Topic

Display Mode

Topic Options

Author

Message

David McKinney

Posted Thursday, August 09, 2007 12:13 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:43 AM
Points: 582, Visits: 1,601

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/dmckinney/3179.asp

Post #389416

likaservice

Posted Friday, December 11, 2009 8:22 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, December 14, 2009 10:16 AM
Points: 20, Visits: 3

That is nice and robust solution! But since triggers can be disabled by privileged users, this won't work for internal access violation...

Post #832978

David McKinney

Posted Friday, December 11, 2009 9:34 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:43 AM
Points: 582, Visits: 1,601

I understand your point, but I would suggest that you could say the same about the data in the target audit tables. i.e. a privileged user would be able to delete / update data.

Whatever solution you use for auditing, you'll have to ensure that appropriate permissions are granted to make sure that the neither the auditing mechanism nor the audited data itself is tampered with.

Post #833034

« Prev Topic | Next Topic »

Permissions