Reset passwords and unlock accounts on Oracle SQL server

To unlock a user account on Oracle SQL:


ALTER USER username ACCOUNT UNLOCK;

 

To reset the password on an Oracle SQL account:


ALTER USER username IDENTIFIED BY a_new_password;