This content has been marked as final. Show 5 replies
check if usr_locked =1 means the user is locked. To unlock this user update database "update usr set usr_locked =0, usr_login_Attempts_ctr=0, where usr_login='XELSYSADM'" and then commit.
If still you are unable to login using existing passwrod. update XELOPERATOR's usr_password encrypted value for XELSYSADM user and then login password as 'XELOPERATOR' later on you can change it.
In worst case you can directly update the PCQ table for setting question and answer for xelsysadm( similar as existing one)
Thanks Nishith. usr_locked is showing as 0 only. I already tried updating the encrypted password of XELOPERATOR into XELSYSADM's password. After that i was tring to login with the password 'xeloperator'. But from your post i am seeing that to be in uppercase ('XELOPERATOR'). So should it work if i try to login with user id XELSYSADM and password XELOPERATOR (uppercase instead of lower case which i previously used).
By default all user login ids will be stored in upper case and while logging into console, case does not matter actually.
Try this update sql to xelsysadm password from xeloperator.
SET USR_PASSWORD=(SELECT A.USR_PASSWORD FROM USR A WHERE UPPER(A.USR_LOGIN) ='XELOPERATOR')