【YashanDB知识库】审计表UNIFIED_AUDIT_TRAIL出现YAS-00220 utf8 sequence ...

【题目分类】功能利用
【关键字】UNIFIED_AUDIT_TRAIL，YAS-00220
【题目描述】当审计对象的SQL语句包含非标准中文字符时，出现YAS-00220 utf8 sequence is wrong，影响审计记录。

1. --第一步：打开审计开关
3. SQL> ALTER SYSTEM SET UNIFIED_AUDITING = true;
7. Succeed.
11. --创建审计策略
13. CREATE AUDIT POLICY up2
15.   ACTIONS DROP TABLE,DELETE ON sales.area,INSERT ON sales.area,UPDATE ON sales.area,ALL ON sales.sales_info;
19. AUDIT POLICY up2;
23. --第二步：执行操作被正常记录
25. SQL> conn sales/sales
29. Connected to:
31. YashanDB Server Enterprise Edition Release 23.2.7.100 x86_64 - Linux
35. SQL> UPDATE area SET DHQ='guangzhou' WHERE area_no='01';
39. 1 row affected.
43. SQL> commit;
47. Succeed.
51. SQL> SELECT dbusername,event_timestamp,sql_text,object_schema
53. FROM UNIFIED_AUDIT_TRAIL
55. WHERE dbusername='SALES'; 2 3
59. DBUSERNAME EVENT_TIMESTAMP SQL_TEXT OBJECT_SCHEMA
61. ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------
63. SALES 2024-12-11 09:52:27.602837 UPDATE area SET DHQ='guangzhou' WHERE area_no='01' SALES
67. 1 row fetched.
71. --第三步：其中 '广.' 为非正常中文字段，查看审计表出现报错
73. SQL> UPDATE area SET DHQ='广.' WHERE area_no='01';
77. 1 row affected.
81. SQL> commit;
85. Succeed.
89. SQL> SELECT dbusername,event_timestamp,sql_text,object_schema
91. FROM UNIFIED_AUDIT_TRAIL
93. WHERE dbusername='SALES'; 2 3
97. DBUSERNAME EVENT_TIMESTAMP SQL_TEXT OBJECT_SCHEMA
99. ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------
101. SALES 2024-12-11 09:52:27.602837 UPDATE area SET DHQ='guangzhou' WHERE area_no='01' SALES
105. YAS-00220 utf8 sequence is wrong
109. --第四步：执行操作无法被正常记录
111. SQL> UPDATE area SET DHQ='guangzhou' WHERE area_no='01';
115. 1 row affected.
119. SQL> commit;
123. Succeed.
127. SQL> SELECT dbusername,event_timestamp,sql_text,object_schema FROM UNIFIED_AUDIT_TRAIL WHERE dbusername='SALES';
131. DBUSERNAME EVENT_TIMESTAMP SQL_TEXT OBJECT_SCHEMA
133. ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------
135. SALES 2024-12-11 09:52:27.602837 UPDATE area SET DHQ='guangzhou' WHERE area_no='01' SALES
139. YAS-00220 utf8 sequence is wrong

复制代码

【题目缘故原由分析】数据库BUG
【办理/规避方法】制止包含非正常中文字符，重新整理审计表。

1. BEGIN
3.   DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL (
5.         DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
7.         true);
9. END;
11. /

复制代码

【影响范围】23.2.9.xxx前的所有版本
【修复版本】-

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。