Changes a user’s password.
alter user user
set password {new_passwd | null}
[verify password old_passwd]
The login name whose password you want to modify.
The new password. It can be up to 30 characters long and include letters, numerals, and symbols. Case is significant. If the password contains spaces, enclose the password in quotation marks. When you create or alter a user login name, you must specify a password or “null.” A null password lets a user log in immediately without being prompted for a password string.
Enter your current password. Users who do not have “sa” permission must enter this clause.
The user with login name “louise” has changed her own password from “EnnuI” to “somNIfic”:
alter user louise set password somNIfic verify password EnnuI
If your Replication Server uses ERSSD, you can change the ERSSD primary user password using the alter user command:
alter user user set password new_passwd
If this user name matches the ERSSD primary user name, ERSSD updates the rs_users table, issues sp_password at ERSSD to change the password, and updates the configuration file line RSSD_primary_pw.
Users with “sa” permission can omit the verify password clause. Other users must provide this clause in order to change their own passwords.
alter user requires "sa" permission when altering another user’s password.
