Changing Passwords for Roles

To change the password for a role, first drop the existing password, then add the new password.

alter role doctor_role drop passwd
alter role doctor_role add passwd "physician"
Note: Passwords that existed before SAP ASE version 12.x and that are attached to user-defined roles do not expire.