Change a Replication Server Password

The replication system administrator can change the password of any user with the alter user command. A user can change his or her own password.

The syntax for alter user is:

alter user user
set password {new_password | null} 
[verify password old_password]
[set password_parameter to 'parameter_value']

The same rules that you use for specifying the password using create user also apply to alter user.

The verify password clause, which prevents users from altering each other’s passwords, is required for users without sa permission.

For example, if the user with login name “louise” wants to change her own password from “EnnuI” to “somNIfic”, she should enter:

alter user louise
 set password somNIfic
 verify password EnnuI

As the administrator, you can set the password expiration interval for the user. For example, to change the password and password expiration interval of user jsmith to 60 days, enter:

alter user jsmith
set password to newpass
set password_expiration to '60'

See Replication Server Reference Manual > Replication Server Commands > alter user.