|
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; |
|
|