The sp_modifylogin options passwd expiration, min passwd length and max failed_logins supports the clear value which clears the previous setting of the attribute for the specific user.
Example: Set the password expiration value to 30:
sp_modifylogin “John”, “passwd expiration”, 30go
User John’s password will expire in 30 days even though the system default for passwd expiration is 90 days.
To clear the passwd expiration value for user John:
sp_modifylogin “John”, “passwd expiration”, “clear”go
Adaptive Server displays a message that the login-specific attribute has been removed. The attribute is now set to the system default.
If you use the clear option for a
user attribute that does not have a previously set value, Adaptive
Server displays a message that there is no login-specific attribute
set. However, the user continues to use the system default for that
attribute.
