Help Center/ GaussDB/ FAQs/ Database Parameter Modification/ How Do I Enable the Audit of INSERT, UPDATE, and DELETE Operations in GaussDB?
Updated on 2024-09-13 GMT+08:00

How Do I Enable the Audit of INSERT, UPDATE, and DELETE Operations in GaussDB?

You can enable the audit of INSERT, UPDATE, and DELETE operations on the GaussDB console. Specifically, perform the following operations:

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB.
  4. On the Instances page, click the name of the target instance to go to the Basic Information page.
  5. In the navigation pane on the left, choose Parameters.
  6. Search for the audit_dml_state parameter in the search box.
  7. Select a value from the drop-down list and click Save.

    • 0: Disable the function.
    • 1: Enable the function.

  8. In the displayed dialog box, click OK.