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 -> Re: How to get the user login history???

Re: How to get the user login history???

From: Howard J. Rogers <howardjr_at_www.com>
Date: Mon, 3 Sep 2001 15:03:12 +1000
Message-ID: <3b930e01$1@news.iprimus.com.au>


Version?

If 8i, you can create a trigger 'after Logon on database', which could (for example) populate some log table you've created, with details of the User's name, date, time etc.

A simple example might be:

create or replace trigger logon_capture
after logon on database
when (user='Fred' or user like 'M%')
begin
insert into schema.tablename
values ('Logon ' || USER || ' at ' || to_char(sysdate, 'YYY-MM-DD: HH24:MI:SS'));
commit;
end;

But all that only works in 8i. You really ought to include at least an Oracle version when you post here... there are now getting on for a dozen of them!

Regards
HJR "K.P, Ng" <kpng_at_sywg.com.hk> wrote in message news:9munhs$qrv4_at_imsp212.netvigator.com...
> How can I get the user login history, since oracle instance shows the only
> current login information.
>
> Pang
>
>
Received on Mon Sep 03 2001 - 00:03:12 CDT

Original text of this message

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