Why Does MySQL Auditing Still Create Log Entries when Filtering DML Statements? MySQL Enterprise Audit (Doc ID 2916407.1)

Last updated on DECEMBER 18, 2022

Applies to:

Goal

When creating a MySQL Audit filter to abort a DML on particular table, it is noted as not working as expected as records are still being inserted into the records.
There are no entries showing up in the mysqld error logs so why is the filtering being ignored?

Here is an example of the filter in question (formatted for easier reading):

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.