- 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())
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:
Fullname: Joe Smith
Default Database: dbname
Default Language: us_english
Auto Login Script:
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
SAP Adaptive Server Enterprise (ASE) 16.0
SAP Adaptive Server Enterprise 16.0
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis 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.