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. |