Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
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 |