K2B Audit SQL Scripts

K2B Audit generates GeneXus code and SQL statements, sometimes embedded in the code, to create database triggers that audit a database.

To solve some restricted deployment scenarios it also generates SQL scripts, the preferred mechanism to comunicate with database administrators.

Generated SQL scripts are:

• K2BAuditInitializationCommands.sql script
• K2BAuditCreateAllTriggers.sql script
• K2BAuditDropAllTriggers.sql script
• For each audited transaction table:
  • A create insert trigger script
  • A drop insert trigger script
  • A create update trigger script
  • A drop update trigger script
  • A create delete trigger script
  • A drop delete trigger script
• K2BAuditReorganization.sql script

IMPORTANT: Scripts may contain replaceable keywords as described in SQL scripts replaceable keywords.