The following Sybase Central changes for ESD #2 affect login management. (For an overview of this functionality, see Chapter 2 of the Sybase IQ Reference Manual and “Managing User IDs and Permissions” in Chapter 12 of the Sybase IQ System Administration Guide.)
For an IQ database, the Allowed to connect check box in the User Property Sheet, General tab is renamed to Enable Password. It continues to function in the General tab as before: checking the Enable Password checkbooks sets the password to non-null.
If login management is disabled, the Login Management tab is displayed but not enabled, while viewing the user/group properties.
If login management is enabled:
Create Group and Create User wizards contain an additional page that allows the user to lock the new user/group being created out of the current database. The page also lets you lock out the user or group on specific servers in a multiplex.
The Login Management tab in the user/group properties sheet is enabled based on two factors:
Passwords must be enabled by checking the “Enable Password” checkbooks in the General tab.
Login management is enabled via the Database Property sheet Login Management tab.