Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : Auditing : Enabling and disabling auditing : Disabling auditing
Disabling auditing
Use the command PROUTIL DISABLEAUDITING to disable auditing for a database. If a database has data in the audit data tables, _aud-audit-data and _aud-audit-data-value, when the command is issued, the database is deactivated rather than disabled. The syntax of the DISABLEAUDITING command is:
proutil db-name -C disableauditing
The following message is displayed when auditing is deactivated:
Auditing was not fully disabled because auditing data tables are not empty.
Auditing has been deactivated, no additional auditing records will be recorded.
To fully disable auditing, the _aud-audit-data and _aud-audit-data-value tables must be empty. The following procedure provides the steps to disable auditing on a database that currently has auditing deactivated.
To disable auditing on a deactivated database:
1. Activate auditing with PROUTIL ENABLEAUDITING.
Because the database is deactivated, issuing PROUTIL ENABLEAUDITING has the effect of activating auditing.
2. Empty the audit data tables.
Use your audit archiving tools or PROUTIL AUDITARCHIVE to remove the data from the _aud-audit-data and _aud-audit-data-value tables.
Note: Not all audit records are deleted by PROUTIL AUDITARCHIVE. For example, if your audit policies audit the execution of AUDITARCHIVE, you will need to use another method to remove all the data from the audit data tables.
3. Disable auditing with PROUTIL DISABLEAUDITNG. Because the audit data tables are empty, auditing is completely disabled.
When auditing is successfully disabled, the following message is displayed:
Auditing has been disabled for database db-name. (12490)