Auditing capabilities are available for ANY table within the SDW without ANY CHANGES required to the source table. A generic trigger will capture any inserts, updates, deletion or truncation of the data within a table configured for capture. The existing data (original) along with the new data are stored in the logged actions table within the audit schema.
Information stored for each row change includes:
By having access to all this information it is possible to rebuild tables of data from a specific time.
Use the following to set up a table for auditing. You would need to run this statement for every table you wish to audit.
SELECT audit.audit_table('schema_name.table_name'); |
You can either use pgAdmin III or a Stored Procedure task in Studio - using the at_wkf_executecmd as a wrapper to the SQL.