Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7443

Server audit: If both QUERY_DML and QUERY_DDL are set, nothing is logged

    XMLWordPrintable

Details

    Description

      Only QUERY_DML - OK

      MariaDB [test]> set global server_audit_events='QUERY_DML';
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> select 1;
      +---+
      | 1 |
      +---+
      | 1 |
      +---+
      1 row in set (0.00 sec)
       
      MariaDB [test]> # logged
       
      MariaDB [test]> create table if not exists tt as select 1;
      Query OK, 0 rows affected, 1 warning (0.00 sec)
       
      MariaDB [test]> # not logged

      Only QUERY_DDL - OK

      MariaDB [test]> set global server_audit_events='QUERY_DDL';
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> select 2;
      +---+
      | 2 |
      +---+
      | 2 |
      +---+
      1 row in set (0.00 sec)
       
      MariaDB [test]> # not logged
       
      MariaDB [test]> create table if not exists tt as select 2;
      Query OK, 0 rows affected, 1 warning (0.00 sec)
       
      MariaDB [test]> # logged

      QUERY_DML and QUERY_DDL together - nothing is logged

      MariaDB [test]> set global server_audit_events='QUERY_DDL,QUERY_DML';
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> select 3;
      +---+
      | 3 |
      +---+
      | 3 |
      +---+
      1 row in set (0.00 sec)
       
      MariaDB [test]> # not logged
       
      MariaDB [test]> create table if not exists tt as select 3;
      Query OK, 0 rows affected, 1 warning (0.00 sec)
       
      MariaDB [test]> # not logged

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.