Query to reset User if not logged on for long or to retain password if the user is asked to forcibly change the password (Below is the example for user named administrator)
update FRM_USERATTRIBS set USERATTRIBS_USERSTATUS ='A',
MODIFIEDON = getdate(), USERATTRIBS_WRONG_PWD_ATTEMPT_COUNT=0, USERATTRIBS_LASTLOGGEDON =getdate() where USERATTRIBS_NAME='administrator'
update FRM_USERATTRIBS set USERATTRIBS_USERSTATUS ='A',
MODIFIEDON = getdate(), USERATTRIBS_WRONG_PWD_ATTEMPT_COUNT=0, USERATTRIBS_LASTLOGGEDON =getdate() where USERATTRIBS_NAME='administrator'
No comments:
Post a Comment