The application I am working on uses SQL to store data. Most of the data is fine the way it is, but one of the tables contains information that would be very tempting for some users to alter.
My original plans were to have the application check the identity column and make sure there are no "breaks" in the sequence to show if a user has deleted a row. But I realized this was a poor choice considering that identity values can be "reset" if so desired and it doesn't address tampering (changing values) in the row.
Is anyone aware of a method that can detect, not necessarily prevent, tampering of a table? I read some other ideas online where a column can contain a hash value based on the row and the row previous to it to detect both removal and alterations. I'm not sure if this is a good solution though and thought I would see if anyone had any ideas.