Archives of the TeradataForum

Message Posted: Thu, 08 Sep 2005 @ 22:01:55 GMT

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

assuming you have the authority to see the users using dbc.users (there was a different thread on that recently)

     select * from dbc.users
     where lockedcount = x

where x is whatever your number of attempts your system locks out users

     after (sel maxlogonattempts
     from dbc.syssecdefaults)

if a user fumble-fingers a password, the lockedcount gets incremented by one, after a successful logon or a release password locks command, counter gets reset to zero

Ruth Fenwick
Database Services
Royal Bank of Canada

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