Symptom
Notice the 'Date of Last Password Change' of sp_displaylogin is updated when LDAP user successfully connects to ASE. Need to know why the password is changing and does the password itself is being stored in syslogins as well?
1> sp_displaylogin Administrator
2> go
Suid: 80
Loginame: Administrator
Fullname:
Default Database: master
Default Language:
Auto Login Script:
Configured Authorization:
Locked: NO
Date of Last Password Change: Jun 14 2023 8:25PM
Password expiration interval: 0
Password expired: NO
Minimum password length: 6
Maximum failed logins: 0
Current failed login attempts: 0
Authenticate with: AUTH_DEFAULT
Login Password Encryption: SHA-256
Last login date: Jun 14 2023 8:28PM
Exempt inactive lock: 0
(return status = 0)
Read more...
Environment
SAP Adaptive Server Enterprise
Product
Keywords
LDAP, LDAP authentication, authentication, external authentication mechanism, sp_displaylogin, syslogins, password, user authentication, login, "Date of Last Password Change", Date of Last Password Change: , 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