March 23rd, 2006 08:34 AM
Database Integrity Monitoring
I know that the point of databases is to have data inserted, updated removed... so it's sort of in a state of flux...
However, is software available that has sort of a tripwire approach to database integrity? If not, what ways would be simple to detect if a change has been made to a database? For instance...
...Then if the hash changes, it's been modified. However, I don't know what element has been modified, nor does this seem very efficient.
$result = query('SELECT * from TABLE');
$hash = md5($result);
This will be for a web application honeypot, and I'm looking to build a layer to notify me of an attack...
Thanks in advance