1-- Changes password for the schema.
2-- Add double quotes to new_password in case of special characters
3ALTER USER my_user IDENTIFIED BY new_password;
4-- Unlock a user
5ALTER USER my_user ACCOUNT UNLOCK;
6-- Unlock and change password
7ALTER USER my_user IDENTIFIED BY new_password ACCOUNT UNLOCK;
8-- Force user to change password at first login
9ALTER USER my_user IDENTIFIED BY PASSWORD EXPIRE;