RE: user logging

in oracle 7.x your best bet is to switch on the auditing SQL> audit session by username;
then query the dba_audit_session to get the logon/logoff for that userid..

Rahul

> ----------
> From: Adema, Gosse[SMTP:Gosse.Adema_at_relan.nl]
> Sent: 26 April 2000 12:51
> To: 'Tombs,Peter'; 'oracledba_at_quickdoc.co.uk'
> Subject: RE: user logging
>
> There is a column logon_time in v$session.
>
> Gosse Adema
>
>
> SQL> select username, logon_time from v$session;
>
> USERNAME LOGON_TIME
> ------------------------------ ----------
> 26-04-2000
> 26-04-2000
> 26-04-2000
> 26-04-2000
> 26-04-2000
> 26-04-2000
> 26-04-2000
> 26-04-2000
> 26-04-2000
> CAD32576 26-04-2000
> SYSJCS 26-04-2000
> DBSNMP 26-04-2000
> SYSJCS 26-04-2000
> DBSNMP 26-04-2000
> SYSJCS 26-04-2000
> SYSTEM 26-04-2000
> SYSJCS 26-04-2000
> SYSJCS 26-04-2000
> SYSJCS 26-04-2000
>
> 19 rijen zijn geselecteerd.
>
> -----Oorspronkelijk bericht-----
> Verzonden: dinsdag 25 april 2000 17:15
> Aan: 'oracledba_at_quickdoc.co.uk'
> Onderwerp: user logging
>
>
> Hello,
>
> Can anyone tell me of a way I can tell the time when a user last logged on ?
>
> I'd like to clear out all the user ids that have not been used recently.
>
> Pete
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Wed Apr 26 2000 - 02:02:53 CDT