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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tracking user log on's

Re: Tracking user log on's

From: Siphiwe Memela <siphiwe_at_cm.co.za>
Date: 1998/06/08
Message-ID: <357BD2BC.19CA4EE6@cm.co.za>#1/1

Jim W wrote:
>
> Try this ...
>
> select username, osuser, to_char(logon_time,'DD-Mon-YYYY HH24:MI:SS') time
> from v$session
> where username is not null
> order by time
> /

Another way will be to use Oracle's database auditing. Change the initSID.ora file and insert the line audit_trail=db Then shutdown and restart

Go to an sqlplus or svrmgr session as a user with audit system privilege. Issue the command 'audit session;' This will keep a trail of who has logged on to the db, when, and logoff time and whether the action was successfull or not(you can choose to edit only unsuccessful logons by doing 'audit session whenever not successful;' instead of just 'audit session;')

Hope this helps.

-- 
Siphiwe Muziwenkosi Memela              <siphiwe_at_cm.co.za>
Computer Management (Pty) Ltd.        Durban, South Africa
----------------------------------------------------------
Boy, oh boy, that lightning sounds clo *|)^*&%&$NO CARRIER
----------------------------------------------------------
Received on Mon Jun 08 1998 - 00:00:00 CDT

Original text of this message

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