Audit Plugin - Multiple Options Improvement
Description
Environment
Smart Checklist
Activity
Oleksandr Kachan June 12, 2023 at 3:12 PM
Looks like this is covered with the functionality implemented for the new audit plugin. There will be a way to configure a filtering rule to log SELECTs matching some DB, table or table filed name.
Sveta Smirnova March 26, 2018 at 6:09 PM
Thank you for the feedback.
Makes sense. Verified as described.
Joshua Hiscocks March 23, 2018 at 8:50 PM
I am using the audit_log_exclude_commands variable to exclude SELECT from the global logs.
This request is to add an option to override this variable with a specific databsae.
For Example:
Globally Exclude all SELECT querys (using audit_log_exclude_commands)
Include SELECT queries for the information_schema database ONLY
Sveta Smirnova March 23, 2018 at 7:27 PM
Thank you for the report.
Please check if option audit_log_exclude_commands, included into version 5.7.14 and up, works for you: https://www.percona.com/doc/percona-server/LATEST/management/audit_log_plugin.html#audit_log_exclude_commands
Details
Details
Assignee
Oleksandr KachanReporter
Joshua HiscocksLabels
Fix versions
Priority
LowSmart Checklist
Open Smart Checklist
Smart Checklist
Add options to the Audit Plugin to allow multiple configurations.
E.g exclude SELECT statements unless they are on information_schema
The aim here is to reduce the output while retaining current feature list.
The ability to overwrite excluded commands with included databases would be very useful.