审计定义-SYS_AUDIT_DEFS

📄字数 1.7K

👁️阅读量加载中...

功能描述

SYS_AUDIT_DEFS系统表用于管理数据库审计定义信息。

字段说明

序号	字段名	类型	说明	V11	V12
0	DB_ID	INTEGER	库ID	√	√
1	USER_ID	INTEGER	用户ID	√	√
2	OBJ_ID	INTEGER	对象ID	√	√
3	OBJ_TYPE	INTEGER	对象类别	√	√
4	AUDIT_MASK	BIGINT	审计项目掩码	√	√
5	RESERVED1	VARCHAR	保留字段	√	√
6	RESERVED2	VARCHAR	保留字段	√	√

AUDIT_MASK

审计项目	成功	失败	所有
AUDIT_CONNECT	4	8	12
AUDIT_DATABASE	16	32	48
AUDIT_USER	64	128	192
AUDIT_ROLE	256	512	768
AUDIT_SCHEMA	1024	2048	3072
AUDIT_TABLE	4096	8192	12288
AUDIT_VIEW	16384	32768	49152
AUDIT_INDEX	65536	131072	196608
AUDIT_PROCEDURE	262144	524288	786432
AUDIT_TRIGGER	1048576	2097152	3145728
AUDIT_SEQUENCE	4194304	8388608	12582912
AUDIT_GRANT	16777216	33554432	50331648
AUDIT_REVOKE	67108864	134217728	201326592
AUDIT_AUDIT	268435456	536870912	805306368
AUDIT_NOAUDIT	1073741824	2147483648	3221225472
AUDIT_INSERT	4294967296	8589934592	12884901888
AUDIT_UPDATE	17179869184	34359738368	51539607552
AUDIT_DELETE	68719476736	137438953472	206158430208
AUDIT_SELECT	274877906944	549755813888	824633720832
AUDIT_LOCK_TAB	1099511627776	2199023255552	3298534883328
AUDIT_EXECUTE	4398046511104	8796093022208	13194139533312
AUDIT_POLICY	17592186044416	35184372088832	52776558133248
AUDIT_USER_POLICY	70368744177664	140737488355328	211106232532992
AUDIT_TAB_POLICY	281474976710656	562949953421312	844424930131968
AUDIT_SPACE	1125899906842620	2251799813685250	3377699720527870
AUDIT_PACKAGE	4503599627370500	9007199254740990	13510798882111500
AUDIT_TYPE	18014398509482000	36028797018964000	54043195528446000
AUDIT_DB_LINK	72057594037927900	144115188075856000	216172782113784000
AUDIT_SYNONYM	288230376151712000	576460752303423000	864691128455135000

应用举例

查询审计项目掩码等信息

sql

SQL> AUDIT TABLE;

SQL> SELECT * FROM SYS_AUDIT_DEFS;
+-------+---------+--------+----------+------------+-----------+-----------+
| DB_ID | USER_ID | OBJ_ID | OBJ_TYPE | AUDIT_MASK | RESERVED1 | RESERVED2 |
+-------+---------+--------+----------+------------+-----------+-----------+
| 1     | 0       | 0      | <NULL>   | 12288      | <NULL>    | <NULL>    |
+-------+---------+--------+----------+------------+-----------+-----------+

SQL> AUDIT VIEW;

SQL> SELECT * FROM SYS_AUDIT_DEFS;
+-------+---------+--------+----------+------------+-----------+-----------+
| DB_ID | USER_ID | OBJ_ID | OBJ_TYPE | AUDIT_MASK | RESERVED1 | RESERVED2 |
+-------+---------+--------+----------+------------+-----------+-----------+
| 1     | 0       | 0      | <NULL>   | 49152      | <NULL>    | <NULL>    |
+-------+---------+--------+----------+------------+-----------+-----------+

查询审计对象等信息

审计定义-SYS_AUDIT_DEFS ​

功能描述 ​

字段说明 ​

应用举例 ​

相关系统表 ​

审计定义-SYS_AUDIT_DEFS

功能描述

字段说明

应用举例

相关系统表