oracle生成登陆日志

DROP TABLE user_login_audit;
 
CREATE TABLE user_login_audit (
     login_time     DATE,
     username        VARCHAR2(30),
     machine          VARCHAR2(30),
        command          VARCHAR2(128)
);
 
CREATE OR REPLACE TRIGGER user_login_trig
     AFTER LOGON ON sys.test
DECLARE
  v_username sys.v_$session.username%TYPE;
  v_machine  sys.v_$session.machine%TYPE;
  v_command  sys.v_$session.command%TYPE;
BEGIN
  SELECT username, machine, command 
    INTO v_username, v_machine, v_command
    FROM sys.v_$session 
   WHERE audsid = USERENV('SESSIONID')
     AND audsid != 0 
     AND ROWNUM = 1;  
 
  INSERT INTO sys.user_login_audit 
     VALUES (SYSDATE, v_username, v_machine, v_command);
END;

评论

1 楼 guji528 2012-06-13  

可以写一下用法吗?能否跟踪登录失败的用户？比如密码错误导致无法登录的用户