Information
Sybase ASE supports expiring passwords after a set interval. The interval can be set on a
global, per user or per role basis. Password expiration is disabled by default.
It is recommended that a system-wide password expiration is set according to your
organizations requirements.
Rationale:
Password expiration potentially mitigates the damage from a compromised account. It also
assists in identifying accounts that are no longer in use.
Solution
1. Connect to the ASE server with a user that has the sso_role and execute the
following SQL statement to set the system-wide password expiration (substitute 90
for a suitable password expiration value based on your organizations
requirements):
exec sp_configure 'systemwide password expiration', 90