GBase8a审计日志相关操作
开启审计日志:
SET GLOBAL audit_log =1; -- 开启日志功能,默认0;
SET GLOBAL log_output = 'table'; -- 设置审计信息存储位置,默认file.为了方便查询,建议存储为表table.
SET long_query_time = 1; -- 时间条件:无条件
创建审计策略:
CREATE AUDIT POLICY update_ddl_policy1 (enable = 'Y', sql_commands = 'SELECT');
CREATE AUDIT POLICY audit_g2_babuser (enable = 'Y',user = 'babuser')
ALTER AUDIT POLICY audit_ids2 SET long_query_time = '1'
ALTER AUDIT POLICY AUDIT_IDS1 SET (SQL_COMMANDS = 'update,delete,load,truncate,drop_table,drop_db')
CREATE AUDIT POLICY update_ddl_policy1 (enable = 'Y', sql_commands = 'LOAD');

浙公网安备 33010602011771号