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: logging who connects

Re: logging who connects

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 1 Jul 1999 09:34:58 +0200
Message-ID: <7lf5kh$g1r$1@news3.saix.net>


Daniel Fong wrote in message <377A67F1.FC3309D8_at_ilog.com>...

>Is there away to get Oracle to log who connects and from where?

v$session can be useful for this. It contains the machine name (NetBIOS name in the case of Windows clients) and operating system user name of all Oracle sessions. There's also terminal and program columns that can be quite useful.

regards,
Billy Received on Thu Jul 01 1999 - 02:34:58 CDT

Original text of this message

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