You may choose to use the systemwide password expiration configuration parameter to establish a password expiration interval, which forces all Adaptive Server users to change their passwords on a regular basis. See Chapter 5, "Setting Configuration Parameters," in the System Administration Guide: Volume 1. Even if you do not use systemwide password expiration, it is important, for security reasons, that users change their passwords periodically.
The configuration parameter is superseded by the password policy settings.
password expiration interval specifies the password expiration interval in days. It can be any value between 0 and 32767, inclusive. For example, if you create a new login on August 1, 2007 at 10:30 a.m., with a password expiration interval of 30 days, the password expires on August 31, 2007 at 10:30 a.m.
The column pwdate in the syslogins table records the date of the last password change. The following query selects all login names whose passwords have not changed since September 15, 2007:
select name, pwdate from syslogins where pwdate < "Sep 15 2007"
