Database Event Trigger

- 사용자의 Logon, Logoff 추적하는 Trigger
CREATE OR REPLACE TRIGGER log_logon
AFTER LOGON ON DATABASE
WHEN (USER='SCOTT' OR USER LIKE 'SYSTEM%')
BEGIN
 INSERT INTO trigger_log VALUES ('LOGON ' || USER, sysdate);
 COMMIT;
END;

CREATE OR REPLACE TRIGGER log_logoff
 BEFORE LOGOFF ON DATABASE
 WHEN (USER='SCOTT' OR USER LIKE 'SYSTEM%')
BEGIN
 INSERT INTO trigger_log VALUES ('LOGOFF ' || USER, sysdate);
 COMMIT;
END