Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 30 Jan 2006 @ 18:18:48 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   Password has expired flag?
 
From:   Vanole, Mike

Is there a dictionary table that has a flag to tell me that a user's password has expired? I can run a query like that below which tells me when a password should expire (or should have) but I'd rather have a flag. The value of 30 below is the password life in days according to system level or profile specified rules from the time it was created. The locked fields don't seem to apply to expiration. The expiration is working.

     select username,
            passwordlastmoddate + 30 as ExpiresOn,
            passwordlastmoddate||' '||passwordlastmodtime as LastChangedDate,
            lockeddate,
            lockedtime,
            lockedcount
     from dbc.users
     where passwordchgdate <= date - 30

Thanks,

Mike



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023