以下是我的配置:SQL> show parameter audit NAME TYPE VALUE----------------...
显示全部以下是我的配置:
SQL> show parameter audit
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
收起