ALTER USER username ACCOUNT LOCK;

ALTER USER username IDENTIFIED BY new_password;

ALTER USER username ACCOUNT UNLOCK;