RE: SQL Server Integrity

["Burton M. Strauss III" <BStrauss () acm org>]

How about doing an export of the table structures and the table data into a
file and running LIDS/Tripwire on THAT?

Note that you need to use the same file name, but train tripwire et al to
ignore the date/time stamp of the unload (as that will change), but the
signature of the text (i.e. your database) won't change.

Obviously, you need to exclude tables that change, but since this is a
scripted item, you can just write the dump commands that are appropriate.

As a benefit, you get a nightly data dump...

-----Burton

> -----Original Message-----
> From: Bénoni MARTIN [mailto:Benoni.MARTIN () libertis ga]
> Sent: Tuesday, September 07, 2004 3:34 AM
> To: security-basics () securityfocus com
> Subject: SQL Server Integrity
>
>
> Hi list !
>
> I was wondering if there was a simple way / tool / ... which will
> check my MS SQL data integrity. I explain : when performing a
> backup of my DBs, I want to check they have not been alterated by
> a hacker or an error. So I'm looking for something as LIDS or
> Tripwire, but which will work on MS SQL.
>
> Any hint / clue would be appreciated !
>
>
>
>
> ------------------------------------------------------------------
> ---------
> Computer Forensics Training at the InfoSec Institute. All of our
> class sizes
> are guaranteed to be 12 students or less to facilitate one-on-one
> interaction with one of our expert instructors. Gain the
> in-demand skills of
> a certified computer examiner, learn to recover trace data left behind by
> fraud, theft, and cybercrime perpetrators. Discover the source of computer
> crime and abuse so that it never happens again.
>
> http://www.infosecinstitute.com/courses/computer_forensics_training.html
> ------------------------------------------------------------------
> ----------


---------------------------------------------------------------------------
Computer Forensics Training at the InfoSec Institute. All of our class sizes
are guaranteed to be 12 students or less to facilitate one-on-one
interaction with one of our expert instructors. Gain the in-demand skills of
a certified computer examiner, learn to recover trace data left behind by
fraud, theft, and cybercrime perpetrators. Discover the source of computer
crime and abuse so that it never happens again.

http://www.infosecinstitute.com/courses/computer_forensics_training.html
----------------------------------------------------------------------------