maria-discuss team mailing list archive

[Ralf Gebhardt <ralf.gebhardt@xxxxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> 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