Is it possible to log all operation, automatically?
Is it possible to log all operation on specific table? For example, any row insertion/update/delete are logged automatically. That log should only readable/writable by 开发者_运维技巧admin.
You should be able to do so using TRIGGERS
:
http://h2database.com/html/features.html#triggers
H2 allows for "injecting" Java classes as triggers, which makes logging of particular events quite simple and extensible
精彩评论