Useful SQL Statements (cont.)
Select username, password from SYS.DBA_USERS; (displays all userids and passwords (DBA use only))
Select username from ALL_USERS; (displays all userids, any user can execute query)
Select * from profile DEFAULT; (displays password management settings, Oracle 8)
Alter profile DEFAULT invalid_logins unlimited; (turns off any lockout parameter for bad passwords)