Oracle - Unlock Account After Exceeding Failed Attempts  

Posted by ReelTym

SQL> select username,account_status
  2  from dba_users
  3  where username in ('SYS','SYSTEM','SCOTT');
 USERNAME                       ACCOUNT_STATUS
 ------------------------------ --------------------------------
 SCOTT                          LOCKED(TIMED)
 SYSTEM                         LOCKED(TIMED)
 SYS                            OPEN
SQL> -- put everything back as was
SQL> alter user scott account unlock;
 User altered.

This entry was posted on Tuesday, March 01, 2011 and is filed under . You can leave a response and follow any responses to this entry through the Subscribe to: Post Comments (Atom) .