SAP Knowledge Base Article - Preview

3735349 - Incorrect syslogins status values (480) - SAP ASE

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.