Hi,

We need to add functionality in the system that will detect if data has been changed directly in the database, some kind of record's checksum.

I would appreciate help pointing me to the possible implementation scenario.

Of course, not entities in the system should be tracked, thus we should be to

1. identify entity to be checksumed
2. onSave / Update calculate checksum of all persistent properties
3. onLoad verify checksum and react (log, message, etc)

Thank you

Pavel Kovalev

Add a version column and write an on-update trigger that would increment it each time a change is made.

I'm sure I understand how application will know based on version number if data was modified manually.

This approach anyway doesnt look good - this functionality must be _application_ specific; not database specific.

If somebody has access database everything (including version) can be changed; triggers disabled, etc