Changes a database user account.
ALTER USER role_name IDENTIFIED BY password REPLACE prev_password
If you are a role that does not have the CREATEROLE privilege, you can run the ALTER USER… IDENTIFIED BY command to change the password. If you use an unauthorized role and PASSWORD_VERIFY_FUNCTION is not NULL in the configuration file, you must include the REPLACE clause and the previous password. If a non-superuser uses the REPLACE clause, the server compares the provided password with the existing password. If the passwords do not match, an error occurs.
|role_name||The name of the role whose password is to be changed.|
|password||The new password of the role.|
|prev_password||The previous password of the role.|
Execute the following statement to change a user password:
ALTER USER john IDENTIFIED BY xyRP35z REPLACE 23PJ74a;