Check User locked status and Release lock in Teradata

To check the user locked Status:

SELECT username,Lockeddate,LockedTime,LockedCount

FROM DBC.USERS

WHERE lockedCount>0;

Release Lock:

MODIFY USER <user> AS RELEASE PASSWORD LOCK;