NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest string /u01/app/oracle/admin/MICSPROD/adump audit_sys_operations boolean TRUE audit_syslog_level string audit_trail string DB, EXTENDED
SQL> select * from dba_stmt_audit_opts;
USER_NAME PROXY_NAME AUDIT_OPTION SUCCESS FAILURE ------------------------------ ------------------------------ ---------------------------------------- ---------- ---------- ALTER SYSTEM BY ACCESS BY ACCESS CREATE SESSION BY ACCESS BY ACCESS TABLE BY ACCESS BY ACCESS ALTER TABLESPACE BY ACCESS BY ACCESS TABLESPACE BY ACCESS BY ACCESS USER BY ACCESS BY ACCESS INDEX BY ACCESS BY ACCESS VIEW BY ACCESS BY ACCESS SEQUENCE BY ACCESS BY ACCESS PROCEDURE BY ACCESS BY ACCESS TRIGGER BY ACCESS BY ACCESS ALTER TABLE BY ACCESS BY ACCESS ALTER DATABASE BY ACCESS BY ACCESS
13 rows selected SQL> select * from dba_obj_audit_opts;
OWNER OBJECT_NAME OBJECT_TYPE ALT AUD COM DEL GRA IND INS LOC REN SEL UPD REF EXE CRE REA WRI FBK ------------------------------ ------------------------------ ----------------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --- --------- --------- --------- --------- --------- SQL> select * from dba_priv_audit_opts;
USER_NAME PROXY_NAME PRIVILEGE SUCCESS FAILURE ------------------------------ ------------------------------ ---------------------------------------- ---------- ---------- ALTER DATABASE BY ACCESS BY ACCESS ALTER TABLESPACE BY ACCESS BY ACCESS CREATE SESSION BY ACCESS BY ACCESS ALTER SYSTEM BY ACCESS BY ACCESS SQL> select * from all_def_audit_opts;
ALT AUD COM DEL GRA IND INS LOC REN SEL UPD REF EXE FBK REA --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --- --------- --------- --------- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- 以下是我的查询SQL: SQL> select ACTION_NAME,count(*) from dba_audit_trail group by ACTION_NAME;
ACTION_NAME COUNT(*) ---------------------------- ---------- LOGOFF BY CLEANUP 2728 CREATE TABLE 43 LOGOFF 2743835 LOGON 177 DROP TABLE 14 CREATE FUNCTION 2 CREATE PROCEDURE 46