In Oracle SQL / PLSQL a user’s password can be changed using ALTER command. Syntax for changing the user password using ALTER command in Oracle SQL / PLSQL is: ALTER USER user_name IDENTIFIED BY new_password; Example: Here we have changed the password for “techhoney” user as “pwdhoney”.