|
|
Re: List of Login Failed [message #61545 is a reply to message #61541] |
Tue, 04 May 2004 22:23 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
Use this code to create a db trigger:
connect system/manager
drop table error_log;
create table error_log
(
error varchar2(20),
username varchar2(20),
timestamp date
)
/
drop trigger log_errors;
create trigger log_errors after servererror on database
begin
IF (IS_SERVERERROR (1017)) THEN
insert into error_log values ('ORA-1017', user, sysdate);
END IF;
end;
/
If a user enters the wrong username/password entry in log_errors table will be added.
Hope that helps,
Trifon Anguelov
DBAclick.com | DBA Forums
|
|
|