Symptom
- Users shown as LDAP in master..syslogins (status &64=64) can still log in with ASE authentication even when "enable ldap user auth" is 0.
- sp_displaylogin shows "Authenticate with: AUTH_DEFAULT" for affected logins.
- @@authmech during successful sessions returns "ase".
- master..syslogins status values include 480 (ASE+LDAP+PAM+Kerberos), indicating multiple authentication bits set.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.x
- SAP Adaptive Server Enterprise (ASE) 15.x
Product
SAP Adaptive Server Enterprise all versions
Keywords
ldap authentication, enable ldap user auth, syslogins status 64, 480, AUTH_DEFAULT, @@authmech, sp_ldapadmin, sp_displaylogin, alter login modify authenticate with, ANY authentication, ase 15.7, mixed authentication flags , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview