create or replace trigger log_errors AFTER SERVERERROR ON DATABASE
BEGIN
IF (IS_SERVERERROR (1017))
THEN insert into gdba_yanggua.logon_errors (Logon_Date_Time, Usr, OS_Usr, Machine, Process, Program, Err_Msg)
SELECT logon_time,sys_context('USERENV','IP_ADDRESS') ,osuser,username,program,process , 'ORA-1017 INVALID PASSWORD'
FROM v$session WHERE audsid = USERENV( 'sessionid' );
end if;
end;
/
logon_errors structure:
LogOn_date_time date
Usr Varchar2(30),
os_usr varchar2(30)
machine varchar2(30)
process varchar2(80),
prgram varchar2(80)
err_msg varchar2(30)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26706/viewspace-521138/ ，如需转载，请注明出处，否则将追究法律责任。
