SAP Knowledge Base Article - Preview

2278412 - "Password column corrupted" shown in sp_displaylogin - SAP ASE

Symptom

Login Password Encryption is showing a "Password column corrupted "message in sp_displaylogin:

1> sp_displaylogin t98560
2> go
Suid: 10 
Loginame: t98560
Fullname: 
Default Database: master
Default Language: 
Auto Login Script: 
Configured Authorization:
Locked: NO
Date of Last Password Change: Feb 11 2016 4:54PM 
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: Password column corrupted
Last login date: 
Exempt inactive lock: 0
(return status = 0)

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

syslogins, "alter login" , KBA , ase , 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.