K0NRAD
2/9/2014 - 8:21 PM

Unlock Oracle user account

Unlock Oracle user account

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;