SAP Knowledge Base Article - Preview

3334523 - The status value in master..syslogins doesn't match the login's real status - SAP ASE

Symptom

  • We are trying to identify logins with passwords haven't been set > 45 days (our password expiration interval) and they haven't logged in for 45 days.
  • There status should be at least 4 (expired), but most are not showing that.

    select name, status, datediff(dd,lastlogindate,getdate()) 
    from master..syslogins 
    where status not in (6) 
    and datediff(dd,lastlogindate,getdate()) > 45
    and datediff(dd,pwdate,getdate()) > 45

     xyzlogin                             2         326       <-- This user shows status 2 (locked), but should show 6 (locked and expired).
    (3019 rows affected)

  • Is there an issue with master..syslogins or is there a way to fix this without going through each one and manually setting the status?
  • This is the sp_displaylogin information for this login:

    Suid: 12345
    Loginame: xyzlogin
    Fullname: Joe Smith
    Default Database: dbname
    Default Language: us_english
    Auto Login Script:
    Configured Authorization:
    Locked: YES
            Date when locked: Sep  7 2022  9:00AM
            Reason: Account locked by ASE by manually executing sp_locklogin
            Locking suid: xxxxxxx
    Date of Last Password Change: Jun  2 2022  7:12AM
    Password expiration interval: 45
    Password expired: YES
    Minimum password length: 8
    Maximum failed logins: 5
    Current failed login attempts: 0
    Authenticate with: AUTH_DEFAULT
    Login Password Encryption: SYB-PROP,SHA-256
    Last login date: Jun 24 2022  9:43AM
    Exempt inactive lock: 0


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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.