See how long an account is locked
From: Lothar Armbrüster <lothar.armbruester_at_t-online.de>
Date: Wed, 12 Aug 2009 18:20:59 +0200
Message-ID: <87vdktj95g.fsf_at_prometeus.nothing.none>
Hello out there,
Date: Wed, 12 Aug 2009 18:20:59 +0200
Message-ID: <87vdktj95g.fsf_at_prometeus.nothing.none>
Hello out there,
I'm experimenting with account locking, password expiry and the like
on Oracle 10.2.0.4.
I've created a profile with PASSWORD_LOCK_TIME 1/24. So when a couple of
logins fail, the account is locked for one hour. This works as expected. In
the Enterprise Manager I see the account as LOCKED(TIMED).
Now the question is, is there a way to determine the time remaining that the
account is locked. DBA_USERS does not have a column showing that. (Or at least
I'm unable to find it ;-)
Knowing the overall time the account is locked, it would suffice to know when the account got locked. But it did not find this information also.
Many thanks in advance,
Lothar
-- Lothar Armbrüster | lothar.armbruester_at_t-online.de Hauptstr. 26 | 65346 Eltville |Received on Wed Aug 12 2009 - 11:20:59 CDT