How to find out if an account has been locked in Oracle 10g Databases · Oracle Databases · Oracle sqlplus /nolog SQL> connect / as sysdba SQL> SELECT username, account_status, password FROM dba_users; Older Listing all users in a Oracle 10g database Newer How to unlock an account in Oracle 10g