Hi Ljr, if I understand your question correctly, you want to filter SELECT Statements to not be audited. Currently filtering by type of statement is only possible by filtering DML or DDL statement groups. You cannot filter only SELECT statements. Ralf On Wed, Nov 2, 2016 at 4:27 AM Ljr Yang <dbmsprog@gmail.com> wrote:
HI, all
We use MariaDB 10.1.18 and CentOS 6.7, today, try to use server audit log.
after execute SET GLOBAL server_audit_events = "query_ddl,query_dml,query_dcl" and SET GLOBAL server_audit_logging = 1 ;
find have not filter "select" statement in audit log
20161102 11:08:52,fm-test-118,root,172.28.10.121,908933,2799737,QUERY,test,'select * from anv01 LIMIT 0, 100',0
-- Ljr _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Ralf Gebhardt, Product Manager MariaDB Corporation Ab | http://www.mariadb.com | m: +49 152-564-823-67