search

trellix-enterprise / mysql-audit

AUDIT Plugin for MySQL. See wiki and readme for description. If you find the plugin useful, please star us on GitHub. We love stars and it's a great way to show your feedback.
Other
232 stars 57 forks source link

Feature not to log statements within stored programs #187

Open go-to-k opened 6 years ago

go-to-k commented 6 years ago

Under existing conditions in the mysql-audit, not only top-level statements but also statements within stored programs are seem to be logged. And it is indistinguishable whether the queries were called within stored programs or called as top-level statements.

Also if I set audit_whitelist_cmds="call_procedure", the CALL statements themselves for stored programs were hidden as expected, but statements within the stored programs were logged.

I think that like "MySQL Enterprise Audit" only top-level statements should be logged, not statements within stored programs such as triggers or stored procedures. Or I want to become to be able to distinguish sub-level statements from top-level statements in audit logs.

aharonrobbins commented 6 years ago

This is a nice feature to have, but we currently have no plans to make this change.