System Administrators and System Security Officers can:
Specify the expiration interval for a login password at creation
Change the expiration interval for a login password
Specify the expiration interval for a role password at creation
Change the expiration interval for a role password
When a password for a login or role is about to expire, a warning message asks the user to contact the System Security Officer.
Password expiration did not affect roles in releases prior to Adaptive Server 12.0. Therefore, in Adaptive Server 12.0 password expiration is deactivated for any existing user-defined role passwords. During the upgrade all user-defined role passwords are stamped as having a password interval of 0.
Use sp_addlogin to set the password expiration interval for a new login. Use sp_modifylogin to change the password expiration interval for an existing login, add a password expiration interval to a login that did not have one, or remove a password expiration interval.