删除金仓数据库KingbaseES中的审计记录

在kingbase.conf中添加审计插件sysaudit

重启数据库

使用审计管理员开启审计
alter system set sysaudit.enable=on;

test=> call sys_reload_conf();
sys_reload_conf
-----------------
t
(1 row)

test=> show sysaudit.enable;

sysaudit.enable
-----------------
on
(1 row)

system用户登录security数据库，尝试删除审计记录

delete from sysaudit_record;

创建测试用户test_user_6

create user test_user_6 with password '123456';

test_user_6用户登录security数据库，尝试删除审计记录

delete from sysaudit_record;