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 <[email protected]> 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 : [email protected] > 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
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
