SETTINGS_WRITE_STRING Procedure

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 for Oracle:

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.

Related Topics

Detailed Configuration

Auditing Status

Options Setting



Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Thursday, March 18, 2021