Adaptive Server version 12.5.4 lets you make rules about passwords for new logins or for reset passwords.
Adaptive Server 12.5.4 lets you specify a wide range of password complexity attributes:
- Set a minimum number of alphabetic characters for the password.
- Specify that the login name should not be a substring of the password.
- Set a minimum number of special characters for the password.
- Set a minimum number of upper case letters for the password.
- Set a minimum number of lower case letters for the password.
- Specify that the password must be reset at first log on.
You can set each of these new options in ASE Plug-in or you can use a new stored procedure
sp_passwordpolicy.