审计表UNIFIED_AUDIT_TRAIL出现YAS-00220 utf8 sequence is wrong

YashanDB

于 2025-01-08 18:35:04 发布

阅读量176

点赞数 1

CC 4.0 BY-SA版权

分类专栏： YashanDB知识库文章标签：数据库崖山数据库 YashanDB

本文链接：https://blog.youkuaiyun.com/cod0410/article/details/145015183

【问题分类】功能使用

【关键字】UNIFIED_AUDIT_TRAIL，YAS-00220

【问题描述】当审计对象的SQL语句包含非标准中文字符时，出现YAS-00220 utf8 sequence is wrong，影响审计记录。

--第一步：打开审计开关

SQL> ALTER SYSTEM SET UNIFIED_AUDITING = true;

 

Succeed.

 

--创建审计策略

CREATE AUDIT POLICY up2

  ACTIONS DROP TABLE,DELETE ON sales.area,INSERT ON sales.area,UPDATE ON sales.area,ALL ON sales.sales_info;

 

AUDIT POLICY up2;

 

--第二步：执行操作被正常记录

SQL> conn sales/sales

 

Connected to:

YashanDB Server Enterprise Edition Release 23.2.7.100 x86_64 - Linux

 

SQL> UPDATE area SET DHQ='guangzhou' WHERE area_no='01';

 

1 row affected.

 

SQL> commit;

 

Succeed.

 

SQL> SELECT dbusername,event_timestamp,sql_text,object_schema

FROM UNIFIED_AUDIT_TRAIL

WHERE dbusername='SALES'; 2 3

 

DBUSERNAME EVENT_TIMESTAMP SQL_TEXT OBJECT_SCHEMA

---------------------------------------------------------------- --------------------------------