Audit Logging (AID072)

In order to track changes to data records, the ADITO Designer can be used for auditing can be activated separately for each data table (separately for data types without LOBs, data incl. CLOBs or data incl. CLOBs and BLOBs). The activation or deactivation of the auditing is reserved to the ADITO administrators. With this all data field changes of users are logged in a central table.

This includes the user login, the timestamp of the change, the executed type of the change, the database alias, the name of the table and column, the new data value, a unique data value, a unique log identifier, and the logging timestamp.

If the initial data values are to be captured, auditing must be activated before importing the data. This log can be used for auditing purposes to generate a list of all data of all data changes for a data record. Since this is not an end user functionality, there is no user interface for this. These evaluations are usually generated by the database administrator. A cleaning or cutting or deleting of data in this log table is not done by ADITO. by ADITO, but the table has to be shortened by the administrator. be shortened.