To log in to SAP Sybase IQ using LDAP user authentication, each user must have an active user ID and password on both the external LDAP server and the SAP Sybase IQ server.
Define passwords when creating users in SAP Sybase IQ. Thereafter, however, maintain any password changes for users configured to use LDAP user authentication on the external LDAP server, not on the SAP Sybase IQ server. The first time a user logs in to SAP Sybase IQ using LDAP user authentication after a password change, the password in the SAP Sybase IQ database for the user account is automatically updated with the new (LDAP defined) password.
If a password is updated in SAP Sybase IQ, the next time the user authenticates using LDAP user authentication, the password in the SAP Sybase IQ database is overwritten with the password from the LDAP server.
Since passwords are automatically synchronized between the LDAP and SAP Sybase IQ servers, if a user is granted the ability to log on using Standard authentication (the password defined in the SAP Sybase IQ database), he or she must still use the LDAP server credentials to authenticate.