Oracle locked accounts
March 31, 2010 19:18:33 Last update: March 31, 2010 19:18:33
Query the
dba_users view to find locked accounts.
SQL> select username, account_status, lock_date from dba_users order by username; USERNAME ACCOUNT_STATUS LOCK_DATE ------------------------------ -------------------------------- --------- ANONYMOUS OPEN CTXSYS EXPIRED & LOCKED 20-NOV-06 DBSNMP EXPIRED & LOCKED 07-FEB-06 DIP EXPIRED & LOCKED 07-FEB-06 FLOWS_020100 EXPIRED & LOCKED 07-FEB-06 FLOWS_FILES EXPIRED & LOCKED 07-FEB-06 HIBERNATE OPEN HR EXPIRED & LOCKED 20-NOV-06 JEMUSER OPEN JPA OPEN MDSYS EXPIRED & LOCKED 07-FEB-06 USERNAME ACCOUNT_STATUS LOCK_DATE ------------------------------ -------------------------------- --------- OUTLN EXPIRED & LOCKED 20-NOV-06 SRDEMO OPEN SYS OPEN SYSTEM OPEN TSMSYS EXPIRED & LOCKED 07-FEB-06 XDB EXPIRED & LOCKED 07-FEB-06 17 rows selected. SQL> alter user hibernate account lock; User altered. SQL> select username, account_status, lock_date from dba_users where username = 'HIBERNATE'; USERNAME ACCOUNT_STATUS LOCK_DATE ------------------------------ -------------------------------- --------- HIBERNATE LOCKED 31-MAR-10
Easy email testing with http://www.ximailstop.com
