Archives of the TeradataForum

Message Posted: Fri, 14 Jul 2006 @ 19:02:29 GMT

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

Try looking at DBC.DBase.LockedDate for that user. (Also LockedTime and LockedCount.)

The value will be null if the user is not locked.

You can use the following SQL to display all locked users:

     SELECT DatabaseName, LockedDate
     FROM   dbc.dbase
     WHERE  RowType = 'U'
     AND    LockedDate IS NOT NULL
     ORDER BY 1

Mike Dempsey
Teradata Client Tools

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