How to audit data change?
In our clients environment, multiple sources will connect to one DB (all through JDBC connections) and perform various operations. Sometimes they found some data was deleted without reason. Thus they want some feature like SQL Server Database Audit Specifications that can log who at what time with which IP deleted data in a specific DB.
I've checked IRIS Audit but I didn't find feature about that . How can we audit and log delete of a known DB? The deletions might be performed by delete statament or truncate table stattement.