ITPub博客

当你遇到不明身份的用户非法尝试登录而导致帐户锁定而影响正常的开发用户或生产环境时，是否会因为找不到那个不法份子而感到抓狂和无耐，那就试试下面的方法吧。create table tab_logon(USERID VARCHAR2(30),WHO VARCHAR2(30),PTS VARCHAR2(30),SERVICE_USER VARCHAR2(30),IP VARCHAR2(30),LOGONDATE DATE,SERVERERROR VARCHAR2(10));CREATE or replace TRIGGER tri_logerror AFTER SERVERERROR ON DATABASEBEGINIF (IS_SERVERERROR (1017)) THENINSERT INTO TAB_LOGON VALUES (SYS_CONTEXT('USERENV', 'SESSIONID'),SYS_CONTEXT('USERENV