Creating a Login Profile

Create a login profile using the Sybase Control Center Administration Console.

1. In the Perspective Resources view, select the servers on which the login profile is to be created and select Administration Console.
   Note: Login profiles are supported in multiple-server or single-server environments.
2. Select ASE Servers > Security > Login Profiles.
3. Select New.
   The Add Login Profile wizard appears.
4. On the Introduction window, select the individual servers on which to create the login profile, or select to create multiple login profiles on all available servers.
   If you create multiple login profiles on different servers, the names of the login profiles are the same on all servers. However, the login profiles on each server can have different default databases, default languages, or authentication mechanisms.
5. On the Login Profile Name window, enter the name of the login profile to create.
6. (Optional) Select:
   1. With attributes derived from an existing login account – to transfer existing login account values to a new login profile.
   2. As default for all login accounts – if you want the new login profile to be the default for all login accounts on the selected servers.
7. (Optional) On the Default Database window, click Specify default database to choose a database to be used as the default for the login profile. Select one of:
   • Use common default database for the login profile on all servers, then select the default database.

     The list of available of databases is based the databases that are common on all servers that have been selected. No servers to select from indicates that there are no common databases available.

   • Use default database for the login profile on individual server, then select the default database .
8. (Optional) On the Default Language window, select Specify default language to choose a language to be used as the default for the login profile. Select one of:
   • Use common default language for the login profile on all servers, then select the default language.

     us_english is the default language, but you can install locale character sets. The additional installed languages and the default language constitute the list of available languages.

   • Use default language for the login profile on individual server, then select the default language.
9. (Optional) On the Authentication window, select Specify authentication to choose an authentication mechanism for the login profile. Select one of:
   • Use common authentication for the login profile on all servers , then select the authentication mechanism.
   • Use default authentication for the login profile on individual server, then select the authentication mechanism.

   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.

10. (Optional) On the More Options window, choose from:

    Options for Login Profiles

    Option	Description
    Track last login	Specify whether to enable last login updates. The default is to track the last login.
    Stale login inactivity period	Specify the length of time a login account can remain inactive before it is locked due to inactivity.
    Login script	Specify a script to be invoked on login.

11. (Optional) Click Summary to verify your selected options.
12. Click Finish to create the login profile.