Background
User is claiming that records are deleted from a specific table, but nobody knows why. They are not sure if it's an application error or done by a user.
Question
Is it possible to monitor / catch / trace delete statements executed against a specific table?
My first idea was to create an event monitor, but I can't limit it to a specific table or a specific kind of statement.
Best Answer
Use the AUDIT TABLE statement on this table using an AUDIT POLICY with the
EXECUTE
category.Or create an
AFTER UPDATE
trigger.