Logins Wizard (Sybase ASE)
Go Up to Sybase ASE Object Wizards
The Login wizard lets you build and submit an sp_addlogin or CREATE LOGIN call, adding a new login with a basic set of specified database, language, and password properties. An additional sp_locklogin call can be issued to lock the new login. The Login wizard also lets you:
- Grant roles to the login
- Create user accounts on databases for the role, optionally with an alias or by changing ownership
To create a new login using a wizard:
- Open a creation wizard for a login. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Logins (Sybase ASE) - Properties.
- Roles panel - for details, see Logins (Sybase ASE) - Roles.
- Users panel - for details, see Logins (Sybase ASE) - Users.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
- Note: Login triggers, configured for individual logins, are also supported. For details, Logins Editor (Sybase ASE).
Contents
Logins (Sybase ASE) - Properties
When creating or editing a login, this tab/panel lets you work with the following settings:
Group | Setting | Description |
---|---|---|
Creation |
Name |
The user login name. |
Full Name |
The full name of the user, an optional but useful identifier. | |
Suid (version 15.7 ^) |
Lets you optionally add a SUID parameter to the generated DDL, specifying a system user ID. | |
General |
Default Database |
The database where the user starts each session. |
Default language |
The language in which prompts and messages are displayed. | |
Profile (version 15.7 ^) |
Lets you add a LOGIN PROFILE parameter: ignore eliminates profile binding while selecting a login profile (if available) binds the profile to this login. | |
Locked or Account Locked |
If selected, the sp_addlogin or CREATE LOGIN call is immediately followed by an sp_locklogin call, locking the new login and effectively disabling it. | |
NOTE: After creating a login, this group also displays an assigned Login trigger. For details, see Logins Editor (Sybase ASE). | ||
Authentication |
Password |
The initial password for the new user. |
Password expiration |
The duration, in days, before the password expires. | |
Minimum password length |
The minimum number of characters a password can contain. | |
Maximum login attempts |
The maximum number of login attempt failures before the login is suspended. | |
Authentication mechanism |
Lets you select ASE, LDAP, PAM, or ANY authentication. | |
Exempt Inactive Lock (version 15.7 ^) |
When selected, an EXEMPT INACTIVE LOCK TRUE parameter is added to the generated DDL, exempting the login from being locked due to inactivity. |
Logins (Sybase ASE) - Roles
When creating or editing a login, this tab/panel lets you grant roles to the login by selecting the the check boxes assocaited with those roles.
For information on activating and deactivating roles for the current login in the current session, see Role Activation.
Logins (Sybase ASE) - Users
When creating or editing a login, this tab/panel lets you maintain database user accounts for a login as follows:
- Add a user account for this login to a database by selecting a database from the Databases where the Login does NOT have a User Account and clicking the Add button. This opens the Add User dialog letting you provide additional details. For more information, see Adding a login account to a database.
- Remove a user account for this login from a database by selecting a database from the Databases where the Login HAS a User Account and clicking the Remove button.
Adding a login account to a database
When adding a user account for a login to a database, the Add user dialog lets you provide details on the method used (sp_adduser, sp_addalias, or sp_changedbowner). Use the following table as a guide to setting options in this dialog:
Setting or Group | Description |
---|---|
User Type |
Lets you select the method by which the user account will be added to the database: USER (sp_adduser), ALIAS (sp_addalias) or DBO (sp_changedbowner). |
Creation |
Login Name - displays the user name from the Master database. If you selected a User Type of USER, the following settings are available: User Name - is a new name for the user in the target database. Group Name - lets you select a group in the target database to which the user will be added. |
Alias |
LoginUserName - If you selected a User Type of ALIAS, this control lets you select the database user name to alias the login name to. |
dbo |
TransferAliasesAndPermissions - If you selected a User Type of DBO, this control lets you transfer aliases and their permissions to the new database owner. |
For more information, see Logins Editor (Sybase ASE).