Requiring new passwords

Your site 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. For information, see Chapter 5, “Setting Configuration Parameters.” Even if you do not use systemwide password expiration, it is important, for security reasons, that users change their passwords periodically.

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, 1997:

select name, pwdate 
from syslogins 
where pwdate < "Sep 15 1997"