In Adaptive Server version 12.5.4, the authenticate with option to sp_modifylogin or sp_addlogin requires that the login use only a specified authentication mechanism. The supported authentication mechanisms are:
ASE
LDAP
PAM
KERBEROS
ANY
Using authenticate with with these supported authentication mechanisms allows you to override the server-wide configuration parameters unified login required, enable ldap user auth, and enable pam user auth.
If more than one external authentication mechanism is configured and a login specific authenticate with option has not been set, the external authentication mechanism is decided based on the following order:
Kerberos
LDAP
PAM
For example, if both PAM and LDAP are configured, then LDAP is chosen for external authentication, not PAM.
At the time of authentication, exactly one external authentication mechanism is attempted. Depending on the value of configuration parameters, ASE authentication may be tried when the external authentication fails.When none of the external authentication mechanisms are configured, Adaptive Server uses ASE authentication.