This question already has an answer here:
Various databases have custom implementations for auditing:
A number of problems exist:
- There is no consistency (different commands, different log formats, etc.)
- There does not appear to be an ANSI SQL standard
- Some of the audits log to files, rather than a table or tables
What ANSI SQL table auditing mechanism is:
- database agnostic; and
- tracks changes that can be queried using SQL (i.e., an audit table, not a log file)?
If no ANSI SQL standard for audit tables exists, then what alternatives exist for database-agnostic auditing (e.g., create a custom audit table) of CRUD operations against all tables in a schema?