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.1 person found this helpful
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).
yes. try with that. But if the problem because question is not defined in that case open PCQ table look at that if there is no entry for xelsysadm(usr_key=1) then insert 3 question (encrypted) similar to given one for others . or copy from any other envirnment and insert into PCQ table1 person found this helpful
By default all user login ids will be stored in upper case and while logging into console, case does not matter actually.1 person found this helpful
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')
The XELOPERATOR password did not work. I manually inserted values in PCQ table for XELSYSADM user and it worked finally. Thanks