Re: Account Locked

From: gazzag <gareth_at_jamms.org>
Date: Fri, 31 Dec 2010 02:54:24 -0800 (PST)
Message-ID: <74bf7acf-1dc2-474f-a341-f555b016d993_at_fo10g2000vbb.googlegroups.com>

On Dec 31, 10:02 am, eliot06 <p.hi..._at_gmail.com> wrote:
> Hi,
> Some one could tel me ?
>
> Sometimes a user account is locked and I do not know why?
>
> Can someone tell me how to log the lock?
>
> thank's

Check out the DBA_USERS view.

E.g.

SQL> select username, account_status, lock_date from dba_users
where account_status != 'OPEN';

Possible values for ACCOUNT_STATUS are:

OPEN : account is open
EXPIRED: the password on the account has expired EXPIRED(GRACE): the password on the account has expired but there is a grace period to change the password
LOCKED(TIMED): account is locked as as there have been more than FAILED_LOGIN_ATTEMPTS unsuccessful logins

Addidionally, the ACCOUNT_STATUS can also be:

EXPIRED(GRACE) & LOCKED(TIMED)
EXPIRED & LOCKED
EXPIRED(GRACE) & LOCKED These are combinations of the above.

For 10gR2, more information can be found here:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4174.htm#i1628672

HTH
-g Received on Fri Dec 31 2010 - 04:54:24 CST