<div>
Look into sp_displaylogin source - it seems like pwd expiration can be stored in three places - 2x in sysattributes and 1x in sysconfigures (that is global serverwide pwd expiration)<br />

<pre><code id="code-603559">/* Password expiration interval */
select @passwdexp = int_value 
from master.dbo.sysattributes
where class = @passeclass 
AND attribute = 0 
AND object = @suid
AND object_cinfo = &quot;login&quot;

if @passwdexp is  NULL
select @passwdexp = int_value 
from master.dbo.sysattributes
where class = 27 
AND attribute = 7

if @passwdexp is  NULL
select @passwdexp = value  
from master.dbo.sysconfigures  
where name = &quot;systemwide password expiration&quot;
</code></pre>
</div>


Look into sp_displaylogin source - it seems like pwd expiration can be stored in three places - 2x in sysattributes and 1x in sysconfigures (that is global serverwide pwd expiration)


/* Password expiration interval */
select @passwdexp = int_value 
from master.dbo.sysattributes
where class = @passeclass 
AND attribute = 0 
AND object = @suid
AND object_cinfo = "login"

if @passwdexp is  NULL
select @passwdexp = int_value 
from master.dbo.sysattributes
where class = 27 
AND attribute = 7

if @passwdexp is  NULL
select @passwdexp = value  
from master.dbo.sysconfigures  
where name = "systemwide password expiration"


<div>
What version of ASE are you working on ?
</div>


<div>
Hi,<br />
I'm working on ASE 15.0.3.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
In syslogins sybase I able to have all login name, but how do I extract information on wheter the account has pwx expiration enable or not, I can use sp_displaylogin but this will only on individual login
</div>
</div>


Hi,
In syslogins sybase I able to have all login name, but how do I extract information on wheter the account has pwx expiration enable or not, I can use sp_displaylogin but this will only on individual login

sybase, how to extract login from syslogins with information and pwd expiration

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.