Cacher is the code snippet organizer for pro developers

SELECT username, account_status FROM dba_users;
ALTER USER <user> ACCOUNT UNLOCK;
ALTER USER <user> IDENTIFIED BY <password>; 
SELECT profile FROM dba_users WHERE username = <user>;
ALTER profile DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED;