oracle生成登陆日志

zldessktin

　　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_trigAFTER LOGON ON sys.testDECLAREv_username sys.v_$session.username%TYPE;v_machine  sys.v_$session.machine%TYPE;v_command  sys.v_$session.command%TYPE;BEGINSELECT username, machine, command INTO v_username, v_machine, v_commandFROM 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;