记录表的防问次数

SQL> show parameter audit;

SQL> conn /as sysdba

SQL> show parameter audit;

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
audit_sys_operations                 boolean     FALSE
audit_trail                          string      NONE

SQL> alter system set audit_trail=DB scope=spfile;

   SUCCEEDED; 

 

SQL> shutdown immediate;

 

SQL> startup

 

SQL> show parameter audit;

 NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
audit_sys_operations                 boolean     FALSE
audit_trail                          string      DB

 

 

SQL> select * from dba_audit_trail;

 

SQL> conn scott/tiger;

 

SQL> audit select,insert,delete on emp by access whenever successful;

   Audit succeeded.

 

SQL> select * from emp;

 

SQL>  delte from emp;

 

SQL> select * from emp;

 

SQL> rollback;

 

SQL> conn /as sysdba

 

SQL> select os_username,username,userhost,terminal,timestamp,action_name from      dba_audit_trail;

    OS_USERNAME USERNAME USERHOST TERMINAL TIMESTAMP ACTION_NAME
1 DOONE/Administrator SCOTT WORKGROUP/DOONE DOONE 2009-5-27 11:40:37 SELECT
2 DOONE/Administrator SCOTT WORKGROUP/DOONE DOONE 2009-5-27 11:41:05 DELETE
3 DOONE/Administrator SCOTT WORKGROUP/DOONE DOONE 2009-5-27 11:41:10 SELECT
4 DOONE/Administrator SCOTT WORKGROUP/DOONE DOONE 2009-5-27 11:46:12 SELECT
5 DOONE/Administrator SCOTT WORKGROUP/DOONE DOONE 2009-5-27 11:46:35 SELECT;

 

成功，如果有什么不足之处，请各位大侠指点指点