Login Policy Properties window: General tab

This tab has the following components:

Name   Shows the name of the login policy.

Type   Shows the type of object.

Options   Lists the login policy options and allows you to review and edit their values:

  • Password life time   Specifies the maximum number of days before the user's password must be changed. The default is Unlimited.

  • Password grace time   Specifies when to display a warning to the user that their password is about to expire. The value is the number of days prior to expiry that the warning should be displayed. The default is 0.

  • Password expiry on next login   Specifies whether the user's password expires after the next login. If the value for this option is on, the user's password expires after the next login. The default is Off.

  • Locked   Specifies whether the user is locked out (unable to connect to the database). A user may be locked out because they exceeded the Maximum Failed Login Attempts setting attempting to log in. The default is Off.

  • Maximum connections   Specifies the maximum number of concurrent connections allowed by the user. The default is Unlimited.

  • Maximum failed login attempts   Specifies the maximum number of failed attempts allowed (since the last successful login) before the login account is locked. The default is Unlimited.

  • Maximum days since login   Specifies the maximum number of days that can elapse between two successive logins by the user. If the number of days exceeds this setting, the user is automatically locked out. The default is Unlimited.

  • Maximum non-DBA connections   Specifies the maximum number of concurrent connections that a user without DBA authority can make. This option is only supported in the root login policy. The default is Unlimited.

Clear All Overridden Values   Click Clear All Overridden Values to clear all of the values in the Overridden Value column. When the values in the Overridden Value column are blank, the login policy inherits its settings from the root policy.

Reset to SQL Anywhere Defaults   Click Reset To SQL Anywhere Defaults to specify the default values for the options in the Options list.

Comment   Provides a place for you to type a text description of the login policy. For example, you could use this area to describe the login policy's purpose in the system.

See also