User Acoount Lock/Unlock

SQL> ALTER USER username ACCOUNT LOCK;
SQL> ALTER USER username ACCOUNT UNLOCK;
To change the password for a user:
SQL> alter user username identified by new_password;
All at once:

-- Expire, forces to change the password at first login
SQL> alter user username identified by password account lock password expire;