审计结果应用示例
- 审计动作(创建表)。sql
SQL> CREATE TABLE audit_info(id INT);
- 查看审计结果。sql
SQL> SELECT * FROM sys_audit_results; SCHEMA_ID | USER_ID | OBJ_ID | OBJ_NAME | OBJ_TYPE | ACTION | SUCCESS | IP | SQL_TEXT | ERR_INFO | OPTIME | AUDIT_TYPE | NODEID | ------------------------------------------------------------------------------ 1 | 1 | 0 | AUDIT_INFO| 5 | 10 | T | 192.168.30.222| CREATE TABLE audit_info(id INT);| <NULL>| 2022-05-11 09:58:25.116 AD | 6 | 1 |