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

Depending upon :-

    You just want to know when they log on     and
    they are coming in via SQL*Net

Then you can examine the listener.log file as that will list them (in a fairly obtuse way).
Grep & Awk time...

Liggs.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tp7n2ft9pcfq64_at_news.demon.nl...
>
> "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
> >
> >
>
> Sigh no version again. It seems like crossposting to groups not supported
by
> all providers (my provider doesn't support comp.databases.oracle) is
> definitely more easy than to type those 3 digits and 2 dots.
>
> The easiest solution, as it is already provided by Oracle, is to enable
> audit
> (init.ora parameter audit_trail has to be changed to 'db' instead of none,
> and the database bounced), after which an 'audit connect' will audit every
> individual connect and disconnect. The audit record is written on (normal)
> disconnect!
> In Oracle 8i you can use the on-logon trigger to develop your own audit
> system.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Sat Sep 08 2001 - 06:06:00 CDT