审计日志详细记录相关操作

#开启审计日志：
gbase> SET long_query_time = 0;
Query OK, 0 rows affected (Elapsed: 00:00:00.11)
gbase> SET GLOBAL audit_log = 1;
Query OK, 0 rows affected (Elapsed: 00:00:00.78)
gbase> CREATE AUDIT POLICY audit_policy_1 ( Enable = 'Y' );
Query OK, 0 rows affected (Elapsed: 00:00:00.21)
gbase> SET GLOBAL log_output = 'table';
Query OK, 0 rows affected (Elapsed: 00:00:00.12)
#新建用户，表，插入数据等操作：
gbase> CREATE USER u_sj identified by 'U_sj@2022';
Query OK, 0 rows affected (Elapsed: 00:00:00.50)
gbase> GRANT ALL ON *.* TO u_sj;
Query OK, 0 rows affected (Elapsed: 00:00:00.16)
gbase> CREATE DATABASE testSJ;
Query OK, 1 row affected (Elapsed: 00:00:00.15)
gbase>  USE testSJ;
Query OK, 0 rows affected (Elapsed: 00:00:00.17)
gbase> CREATE TABLE t1(i int);
Query OK, 0 rows affected (Elapsed: 00:00:00.65)
gbase> INSERT INTO t1 VALUES (1),(2);
Query OK, 2 rows affected (Elapsed: 00:00:00.70)
Records: 2  Duplicates: 0  Warnings: 0
gbase>  INSERT INTO t1 SELECT * FROM t1;
Query OK, 2 rows affected (Elapsed: 00:00:00.62)
Records: 2  Duplicates: 0  Warnings: 0
gbase>  UPDATE t1 SET i = 3;
Query OK, 4 rows affected (Elapsed: 00:00:00.41)
Rows matched: 4  Changed: 4  Warnings: 0
gbase>  DELETE FROM t1;
Query OK, 4 rows affected (Elapsed: 00:00:00.10)
#查看审计日志：
gbase> SELECT start_time,user_host,query_time,rows, LEFT(sql_text, 30), conn_type
-> FROM gbase.audit_log;