ALTER ROLE -- change a database role
ALTER ROLE name IDENTIFIED BY password
ALTER ROLE changes the password of a role. Only superusers or users with the CREATEROLE attribute can use this command. If the role to be altered has the SUPERUSER attribute, then only a superuser can give this command. Note that unless the role has the LOGIN attribute, the password serves no real purpose.
name
The name of the role whose password is to be altered.
password
The role’s new password.
Use GRANT and REVOKE to change a role’s memberships.
Change a role’s password:
ALTER ROLE admins IDENTIFIED BY xyRP35z;
See Also
CREATE ROLE, DROP ROLE, GRANT, REVOKE, SET ROLE
