K2BAudit Settings (prior to 6.0)

Introduction

K2BAudit settings is a special object in a GeneXus KB that contains configuration options for K2BAudit. Using this options the developer can choose:

  1. How names are generated for procedures and triggers (see the "Naming" section).
  2. The DBMS for which triggers should be generated (see the "Platforms" section).
  3. The behaviour of the "Reorganize" action (see the "Reorganize" section).

Location

This object is available in the "Preferences" section of the "Knowledge Base Navigator".

K2BAuditSettingsLocation(upto6.0)
K2BAudit settings object location

Properties

Category Name Value
Naming Insert Trigger Name Determines the default value for the "Insert Trigger Name" in tables. The value "<Table>" will be replaced with the table name.
Update Trigger Name Determines the default value for the "Update Trigger Name" in tables. The value "<Table>" will be replaced with the table name.
Delete Trigger Name Determines the default value for the "Delete Trigger Name" in tables. The value "<Table>" will be replaced with the table name.
Create Metadata Name Determines the name used to generate the "Create Metadata" procedure associated with a transaction level. The value "<Table>" will be replaced with the associated table name.
Create Trigger DBMS Determines the name used to generate the procedure that collects the trigger definitions associated with a transaction level. The value "<Table>" will be replaced with the associated table name, and the value "<Dbms>" will be replaced with the DBMS name.
Create Operation DBMS Determines the name used to generate the procedure that contains the trigger definition associated with a transaction level for an specific operation. The value "<Table>" will be replaced with the associated table name, and the value "<Dbms>" will be replaced with the DBMS name.
Set Attribute Description Proc Determines the name used to generate procedure that updates the attribute definitions associated with a transaction level in the audit database. The value "<Table>" will be replaced with the associated table name.
Platforms Generate for MySQL Determines if K2BAudit should generate triggers for MySQL or not.
Generate for Oracle Determines if K2BAudit should generate triggers for Oracle or not.
Generate for SQL Server Determines if K2BAudit should generate triggers for SQL Server or not.
Generate for PostgreSQL Determines if K2BAudit should generate triggers for PostgreSQL or not.
Generate for Other Determines if K2BAudit should generate triggers for Other DBMS or not. If this option is set, the developer must provide DKT files that implement the trigger generation.
Generate for SQLServer 2000 Determines if K2BAudit should generate triggers for SQLServer 2000 or not.
Generate for DB2 Determines if K2BAudit should generate triggers for DB2 or not.
Reorganize Generate Only On Reorganize Determines if the K2BAuditReorganize procedure should be executed after being generated via the "Reorganize" option.
Run Reorganization On New Thread Determines if the "Reorganize" action should run in a new thread, or in the UI thread.
Set descriptions to attributes Determines if Attribute descriptions should be stored in the audit database.
Audit LUW Determines if the LUW information should be included in audit records.
Not in transaction attributes Determines how K2BAudit should behave when a table is audited but the table contains attributes that are not present in the audited transaction.
Audit updates with no changes Determines if K2BAudit should record changes where no attributes were modified.