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  <userAS RELEASE PASSWORD LOCK;

Comments