Manage Logins

Each Adaptive Server user must have a login account identified by a unique login name and a password.

Note: Only a system security officer can create, modify, or delete login accounts.

Login Accounts

Users must have a login account with a unique name and password to access a server. When a login account is added to one or more servers, the account is given a unique system user ID, which identifies the users regardless of the server being used. Once a login account is created, a user account is created for users to access individual database. Login profiles can be associated with a login account to manage attributes such as the default database, default language, authentication mechanism, tracking the login, setting inactivity periods, and invoking login scripts.

Options for Managing Login Accounts

Grant roles to logins
Map users to logins
Map client users to logins
Assign login profiles to login accounts (in Adaptive Server version 15.7 and higher).
Lock login accounts
Expire login accounts
Set the number of failed logins
Configure passwords parameters at the server level
Change the password for a specific login

Creating a Login
The system security officer (SSO) creates a login account for each user.
Login Properties
Use the Administration Console option on your Adaptive Server to view or modify login properties.
Configuring Login Password Properties
Use the Administration Console option to manage password properties for login accounts.
Changing a Login Password
Change passwords and parameters for login accounts using the Administration Console.
Displaying Login Account Properties
View or modify properties of login accounts using the Administration Console.
Assigning Login Profiles to a Login
Manage attributes of login accounts by assigning a login profile to an individual login, a subset of logins, or all logins.
Deleting a Login
Sybase Control Center helps you delete database objects, or the database itself.

Parent topic: Security