MAX_FAILED_LOGIN_ATTEMPTS Option

Specifies the maximum number of failed attempts, since the last successful attempt, to log into the user account before the account is locked.

For details, see SQL Anywhere Server – Database Administration > Configuring your database > Managing user IDs, authorities, and permissions > Managing login policies.

Note: This reference points to SQL Anywhere documentation.

Each node in a multiplex environment maintains its own failed login count and last failed login time for a given user.

In Sybase IQ, MAX_FAILED_LOGIN_ATTEMPTS applies to all users, including those with DBA authority. A Sybase IQ server unlocks a user account with DBA authority automatically 15 minutes after the last failed login attempt.

A user with DBA authority cannot log in if:

The login exceeds the maximum number of failed login attempts allowed by the user's login policy,

and
The current time and the last failed login time for the user differ by less than 15 minutes.

After a database is restarted, a user with DBA authority is allowed one successful login attempt even if the number of failed login attempts exceeds the maximum allowed by the login policy.