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;