Login Properties

• Full name – allows for easier identification name for the login account.
• Default database – if not specified, the master database.
• Default language – if not specified, us_english is the default.
• Authentication – specify the external authentication mechanism:
  • ANY
  • ASE
  • KERBEROS
  • LDAP
  • PAM

  If you select ANY (the default) as the authentication mechanism, Adaptive Server checks for a defined external authentication mechanism and uses it, if it exist. Otherwise, the ASE mechanism is used. The default is ANY.

• Temp DB binding – binds logins to a temporary database in the default temporary database group.

• Invalid password or NULL – specify new password for the login account.
• Password has expired – the account owner must change the login password.
• Account is locked – lock the login account.
• Password last set – indicates when the password was changed.
• Max failed logins – the number of login attempts allowed, after which the account is locked.
• Min password length – minimum password length required for the login account.
• Password expiration intervals (days) – the number of days until the password expires.
• CPU time accumulated – tracks of the amount of CPU time.
• I/O time accumulated – tracks the amount time spent processing input and output operations.

Displays a list of databases that are owned by the specified login account.

Displays a list of roles granted to the account. You can add or remove roles that have been granted to the selected login. Click Predicates to view the role activation SQL text for predicates.

Displays a list of users or aliases that are bound to the account. You can add or remove users to or from the account.

Displays a list of client users mapped to the account. You can add or remove client users to or from the account.