Logins Editor (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Editors

The Logins Editor lets you manage basic properties for a login, associated users and roles, and accounting.

To edit a login:

  1. Open an editor on the login. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you work with the following properties set when creating the login: Name, FullName, Default database, Default language, Locked (or Account Locked), Password, Password expiration, Minimum password length, Maximum Login attempts, and Authentication Mechanism. Against Sybase 15.7 and higher, servers, Profile (with an additional default option available) and Exempt Inactive Lock parameters are available. For detailed information on these settings, see Logins Wizard (Sybase ASE). In addition, when editing an existing login, you have access to the following settings:

Is currently logged in

Displays whether the user is currently logged in.

Login trigger

Displays the login trigger currently configured for this login. This is the stored procedure automatically executed when the user logs on. For information on configuring login triggers for a login, see Add/Modify Login Trigger and Drop Login Trigger.


Lets you maintain database user accounts for a login. For more detailed information, see Logins (Sybase ASE) - Users.


Lets you maintain the roles granted to this login. For more detailed information, see Logins (Sybase ASE) - Users. For information on activating and deactivating roles for the current login in the current session, see Role Activation.


The Accounting tab of the Logins Editor lets you manage chargeback accounting statistics for every login on the current server. Chargeback accounting statistics are CPU and I/O usage statistics that Sybase ASE accumulates for every login. To start a new accounting period, the system administrator must clear all previous login statistics. Optionally, you can click the Clear Statistics button to start a new accounting interval. The Clear Statistics dialog lets you clear statistics immediately or use scheduling options.


For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.