第19章.txt

oracle操作基础基础基础基础基础基础基础基础基础基础基础基础

例19.1
DROP PROFILE test_profile CASCADE;
CREATE PROFILE test_profile LIMIT
CPU_PER_SESSION 1000  
CPU_PER_CALL 1000   
CONNECT_TIME 200    
IDLE_TIME 30        
SESSIONS_PER_USER 10  
LOGICAL_READS_PER_SESSION  DEFAULT 
LOGICAL_READS_PER_CALL DEFAULT     
PRIVATE_SGA DEFAULT           
COMPOSITE_LIMIT DEFAULT          
FAILED_LOGIN_ATTEMPTS 20        
PASSWORD_LOCK_TIME 30        
PASSWORD_GRACE_TIME 60       
PASSWORD_LIFE_TIME 20      
PASSWORD_REUSE_MAX 5      
PASSWORD_REUSE_TIME UNLIMITED 
PASSWORD_VERIFY_FUNCTION NULL 
;

例19.2 
connect / @oradb as sysdba
ALTER USER stu08 PROFILE test_profile;
ALTER USER stu08 ACCOUNT LOCK;
connect stu08/stu08@oradb;
connect / @oradb as sysdba
ALTER USER stu08 ACCOUNT UNLOCK ;
connect stu08/stu08@oradb;

例19.3
conn sys/sys@oradb as SYSDBA
AUDIT SESSION BY SCOTT;
conn scott/tiger@oradb
DROP TABLE test_audit;
CREATE TABLE test_audit(
  a number,
  b varchar2(20));
INSERT INTO test_audit VALUES(1,'HELLO');
commit;
conn sys/sys@oradb as SYSDBA
COLUMN USERID FORMAT A10
COLUMN USERHOST FORMAT A10
COLUMN TERMINAL FORMAT A10
COLUMN ACTION# FORMAT 9999
SET LINESIZE 500
SET PAGESIZE 200
SELECT USERID,USERHOST,TERMINAL,ACTION#,SUBSTR(COMMENT$TEXT,1,100),  
        SUBSTR(SPARE1,1,20),SUBSTR(SPARE2,1,20) FROM AUD$;
SELECT * FROM DBA_AUDIT_OBJECT;

例19.4
AUDIT SELECT TABLE, INSERT TABLE,DELETE TABLE
  BY ACCESS
  WHENEVER SUCCESSFUL;

例19.5 
AUDIT SELECT , INSERT ,DELETE 
   ON scott.emp
   BY ACCESS
   WHENEVER SUCCESSFUL;