Search only in titles

---

SETTINGS_WRITE_STRING Procedure

Monitoring Processes and Procedures > PAUDIT Auditing > Detailed Configuration

You can change table audit settings using the settings_write_string procedure.

Oracle or Oracle Autonomous Database Example:

To set the table settings to fully audit insert and update operations but ignore any delete operations, use the following code with Oracle or Oracle Autonomous Database:

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.

Related Topics

Detailed Configuration

Auditing Status

Options Setting

---

Last Published Thursday, October 3, 2024