Login Properties

Use the Administration Console option on your Adaptive Server to view or modify login properties.

The Login Properties wizard allows you to perform these actions:

Wizard Option Login Properties
General
  • 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 of the default temporary database group.
Parameters
  • 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.
Databases Owned

Displays a list of databases that are owned by the specified login account. See Displaying Login Account Properties.

Roles

Displays a list of roles granted to the account. You can add or remove roles that have been granted to the selected login. See Managing Roles Granted to Login Accounts.

Users

Displays a list of users or aliases that are bound to the account. You can add or remove users from the account. See Managing Users Mapped to Logins.