Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to save username from a failed login.
I need to save the typed user name from a failed login, be it a valid
or invalid user name for the database.
So far I have made a trigger to catch the event, but where can I find
the user name?
The following trigger catches the event all right, but just stores an
empty string.
create trigger system.login_errors after server error on database
begin
if (is_servererror(1017)) then
insert into baktus.logerrors
(select sys.login_user from dual);
end if;
end;
Oracle 8.1.6 SE on Win NT 4.0 SP6a
Yours Hans Erik Busk
tbf_at_cn.stam.dk
Received on Sun Sep 16 2001 - 06:43:44 CDT
![]() |
![]() |