检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Parent topic: SQL Audit Errors
Parent topic: SQL Audit Errors
Parent topic: SQL Audit Errors
Parent topic: SQL Audit Errors
Statement Audit Database Audit Rules
SQL Audit SQL audit helps users detect SQL standardization, design rationality, and performance issues hidden in code at the development phase. More than 300 audit rules are preset for various SQL statements such as DML, DDL, and PL/SQL.
Statement Audit Viewing Text Audit History Deleting All Audit Records Viewing File Details Viewing Error Files Deleting a File Audit Task Parent topic: SQL Audit
Database Audit Querying Audit Task Details Deleting an Audit Task Parent topic: SQL Audit
SQL Audit Errors UGO.10100001 The SQL text file is too large UGO.10100002 Password encryption or decryption error UGO.10100005 The parameter is incorrect UGO.10100006 The audit task queue is full UGO.10100007 The number of rule templates has reached the limit UGO.10100008 Incorrect
In the History area, view the historical records, including the database type, data source, SQL statement, and audit time. Only the latest 10 records are displayed. Figure 1 Viewing text audit history Click View Details.
Deleting All Audit Records Scenarios You can delete all audit records at a time. Deleted records cannot be restored. Exercise caution when performing this operation. Prerequisites A text has been submitted for audit. Procedure Log in to the UGO console.
Querying Audit Task Details Scenarios You can view details about a database audit task. Prerequisites A database audit task has been created Procedure Log in to the UGO console. In the navigation pane on the left, choose SQL Audit > Database Audit.
Deleting a File Audit Task Scenarios You can delete file audit tasks. Deleted audit tasks cannot be restored. Exercise caution when performing this operation. Prerequisites A file has been uploaded. Procedure Log in to the UGO console.
Parent topic: Creating an Audit Task
Deleting an Audit Task Scenarios You can delete an audit task. Deleted tasks cannot be restored. Exercise caution when performing this operation. Prerequisites An audit task has been created. Procedure Log in to the UGO console.
Audit completed: The audit is complete only after all SQL statements in the file are audited. Audit failed: An exception occurred during the audit. Parent topic: Creating an Audit Task
Rules Viewing Rule Template Details Copying a Rule Template Exporting a Rule Template Deleting a Rule Template Viewing System Rule Details Parent topic: SQL Audit
Creating an Audit Task Creating a Text Audit Task Creating a File Audit Task Creating a Database Audit Task Parent topic: SQL Audit
Audit completed: The database audit is complete only after all database objects are audited. Audit failed: An exception occurred during the audit. Parent topic: Creating an Audit Task
Audit object: CREATE INDEX GaussDB sqltext Major 5 - Click OK. The created template is displayed in the rule template list. Up to 1,000 custom templates can be created. Figure 2 Rule template Parent topic: SQL Audit
