Archives of the TeradataForum

Message Posted: Mon, 17 Jul 2006 @ 11:31:14 GMT

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

Unfortunately, we have some experience with this as our users are constantly forgetting their passwords.

try this....

     sel distinct a.LockedCount as "Nbr Bad Attempts",sum(b.maxlogonattempts
     -
     a.lockedcount) as "Attempts Left",a.username,a.commentstring,
     a.LockedDate as MostRecentLockDate,Substr(Cast(a.LockedTime As
     Char(6)),1,6) as
     MostRecentLockedTime ,
      a.PasswordChgDate,a.CreateTimeStamp
     from dbc.users a , dbc.profileinfo b
     where zeroifnull(a.lockedcount) > 0
     and a.profilename = b.profilename
     order by lockedcount desc,lockeddate desc
     group by 1,3,4,5,6,7,8

The LockedDate will remain set whenever a user is locked - it is simply the LAST time the user was locked.

LockedCount is the number of bad attempts since the last successful attempt. We simply do a "modify user "xxxUSERIDxxx" as release password lock;" ... but you could also clear the LockedDate if you wished.

Harold D. Kleven
SUPERVALU - Data Administration

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