Archives of the TeradataForum

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

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

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>>