MySQL Audit Filter : Example Filter to Collect All DDL commands and Exclude SELECT's on a Given Database

(Doc ID 2215685.1)

Last updated on OCTOBER 31, 2017

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Goal

Describe an example of a Audit plug in filter that logs  all data change(insert,update,delete) for 3 databases for all users.
Also describing a possible way to log the original row value along with the changed values on a table or any other objects in audit log.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms