In this article, we will see how to set maximum failed logins in Sybase. We can set maximum failed attempt by using sp_modifylogin or alter login query. Only a System Administrator or System Security Officer can execute sp_modifylogin. By default value is 0 which means unlimited failed login attempts are possible.
sp_modifylogin Syntax:
sp_modifylogin {loginame | “all overrides”}, option, value
alter login syntax:
alter login login_name
{ [modify attribute_value_pair_list ]
| [add auto activated roles role_name [, role_name_list ]]
| [drop auto activated roles { ALL | role_name [, role_name_list ]}]
| [drop attribute_name_list ]
| [ with password caller_password
modify password [immediately] new_loginName_password ] }
Continue reading How to set maximum failed logins in Sybase