GBase 8a审计日志使用

select * from gbase.audit_policy;
use vc vc1;
drop audit policy ap1;
create audit policy ap1 (long_query_time=0,db='db1',sql_commands='DROP_TABLE');
create audit policy ap2 (db='db1',Obj_type='TABLE(VIEW)',Object='t1');

set global log_output='TABLE';
set global audit_log=1;

select * from gbase.audit_log;
TRUNCATE SELF gbase.audit_log;

Sql_commands：匹配sql类型（INSERT, DELETE, UPDATE, LOAD, CREATE_USER, CREATE_DB, CREATE_TABLE, CREATE_VIEW, CREATE_INDEX, CREATE_PROCEDURE, CREATE_FUNCTION,RENAME_USER, ALTER_DB, ALTER_TABLE, ALTER_PROCEDURE, ALTER_FUNCTION, ALTER_EVENT, DROP_USER, DROP_DB, DROP_TABLE, DROP_VIEW, DROP_INDEX, DROP_PROCEDURE, DROP_FUNCTION, DROP_EVENT, TRUNCATE, GRANT, REVOKE, SELECT，OTHERS）。