RE: Account lock time
Date: Mon, 22 Mar 2010 16:58:16 +0100
Message-ID: <CF9A39CD0F65EA49ADF70FCBF9BC2FF7C08904_at_SW-GNETCW-MBX02.tcads.thomascook.com>
IF you have session auditing on (by access) and IF it was locked due to multiple unsuccessful login attempts, then you could see this in the dba_audit_session view.
mvg,
Jo
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex
Sent: maandag 22 maart 2010 16:42
To: oracle-l_at_freelists.org
Subject: RE: Account lock time
Thanks for the info. It looks like this works if the account is still locked. Unfortunately, the account was already unlocked and now they are trying to find out when/who locked it. Is there a table/column that would tell when/who locked it or do you have to find a table/column that lists unsuccessful attempts multiple times, or what? Seems to be a lot of different audit tables. Not sure what the best way is to find out when it was last locked and who did it once the account has been unlocked.
Subject: RE: Account lock time
Date: Mon, 22 Mar 2010 16:04:40 +0100
From: jo.holvoet_at_thomascook.be
To: cemail_219_at_hotmail.com; oracle-l_at_freelists.org
Dba_users.lock_date will tell you; this maps back to column ltime in sys.user$.
mvg,
Jo
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex
Sent: maandag 22 maart 2010 15:57
To: oracle-l_at_freelists.org
Subject: Account lock time
Is it possible to tell what day/time a particular account is locked? The database is 10.2.0.4
Hotmail is redefining busy with tools for the New Busy. Get more from
your inbox. Sign up now.
<http://www.windowslive.com/campaign/thenewbusy?ocid=PID27925::T:WLMTAGL
:ON:WL:en-US:WM_HMP:032010_2>
Hotmail: Trusted email with Microsoft's powerful SPAM protection. Sign up now. <http://clk.atdmt.com/GBL/go/210850552/direct/01/>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 22 2010 - 10:58:16 CDT