Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to save username from a failed login.

How to save username from a failed login.

From: I hate Spam <tbf_at_cn.stam.dk>
Date: Sun, 16 Sep 2001 13:43:44 +0200
Message-ID: <e8s6qt0tjaprh2au3ecj3fr8bf520ebf78@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US