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');

posted @ 2025-07-30 14:57  CaoYuanPengPeng  阅读(23)  评论(0)    收藏  举报