You can change table audit settings using the settings_write_string procedure.
Oracle Example:
To set the table settings to fully audit insert and update operations but ignore any delete operations, use the following code with Oracle:
exec settings_write_string('330','database.audit.TASK','Options');
Microsoft SQL Server Example:
To set the table settings to fully audit insert and update operations but ignore any delete operations, use the following code with Microsoft SQL Server:
exec settings_write_string '330','database.audit.TASK','Options'
Note: Changes to auditing settings will not appear immediately in the application. The program will need to close the database connection and then reconnect to the database to get the new settings.