Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the user login history???
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