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