Require User to Change Password
Overview
Enforce different password requirements depending on which user password is required to be changed.
Details
As a system administrator, you can require users to change their passwords by selecting the appropriate options on the User Password form, based on the type of password that is required to be changed.
When a user is required to change their Login (Alias) password, even though the 'User must change' option is not selected for the Signature password, the user must change both passwords by entering the old password for both the Alias and Signature logins and also the new passwords for both.

TIER acts as though selecting the 'User must change' option for the Alias signature only is the same as selecting the 'User must change' check box for both the Alias and Signature logins.

However, when the user is required to change only their Signature password, the requirements change. The user is not required to change their Alias password, but they must still enter the original password in all three fields: Enter Old Password, Enter New Password, and Retype New Password. Then in the Signature password section, the user must enter the password in all three fields: Enter Old Password, Enter New Password, and Retype New Password.

SQL Administrators can use the following script to force a user to change their password.
UPDATE dbo.T4W_USERS SET OP MUSTCHANGEUSERPW = 'T', OP MUSTCHANGESIGPW = 'T' WHERE....
