Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8G8QiV17019 for ; Tue, 16 Sep 2003 03:26:44 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8G8QhF17013 for ; Tue, 16 Sep 2003 03:26:43 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.5/8.12.5) with ESMTP id h8G5o1IA020347 for ; Mon, 15 Sep 2003 22:50:28 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.5/8.12.5/Submit) id h8G5jK3Z018576 for oracle-l@orafaq.net; Mon, 15 Sep 2003 22:45:21 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005CFF90; Mon, 15 Sep 2003 22:44:24 -0800 Message-ID: Date: Mon, 15 Sep 2003 22:44:24 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Subject: RE: Last log in Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C37C15.B3559A38" ------_=_NextPart_001_01C37C15.B3559A38 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Todd, Bao - Thank you all for your input -I'm following both scenarios and also = trying out a trigger which I'll avail as soon as done with. =20 Cheers, CSW Simon. =20 -----Original Message----- Sent: Monday, September 15, 2003 11:43 AM To: Simon Waibale; LazyDBA.com Discussion =20 I think this is good: =20 http://www.petefinnigan.com/tools.htm http://www.engin.umich.edu/caen/wls/software/oracle/server.901/a90117/aud= it.h tm =20 Rgds, =20 Bao -----Original Message----- From: waibals@mtn.co.ug [mailto:waibals@mtn.co.ug] Sent: Monday, September 15, 2003 2:31 PM To: LazyDBA.com Discussion Subject: Last log in Hi all- How can tell when an oracle user last logged in the database -ie I need a view from which to select. =20 Cheers and regards, =20 CSW Simon. ------_=_NextPart_001_01C37C15.B3559A38 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Re: Trapping of Rogue Statement

Todd, Bao –

Thank you all for your input = –I’m following both scenarios and also trying out a trigger which I’ll = avail as soon as done with.

 

Cheers,

=

CSW = Simon.

 

-----Original = Message-----
From: Bao, Nguyen Gia [mailto:Bao.Nguyen@se1.bp.com]
Sent: = Monday, September 15, = 2003 11:43 AM
To: Simon Waibale; = LazyDBA.com Discussion
Subject: RE: Last log = in

 

-----Original Message-----
From: waibals@mtn.co.ug [mailto:waibals@mtn.co.ug]
Sent: = Monday, September 15, = 2003 2:31 PM
To: LazyDBA.com = Discussion
Subject: Last log = in

Hi = all-

How can tell = when an oracle user last logged in the database –ie I need a view from = which to select.

 =

Cheers and = regards,

 =

CSW = Simon.

=00 ------_=_NextPart_001_01C37C15.B3559A38-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: