Is there a way to recover a lost CTM SysAdmin password? The customer is using CTM v9 on a Sun station and Oracle database.
I found a discussion in here, the same problem but in CTM8.
is this (below) solution still valid for the CTM9 and Oracle Database?
-----------------------------------
Hi Randall,
Use this SQL command sequence
this will reset the pwd to Ctm123!
update User_Table set UserLoginDisabled = 0 where UserName ='SysAdmin';
update User_Table set LastLoginTime = Null where UserName = 'SysAdmin';
update User_Table set LOCKEDSTATE = 0 where UserName = 'SysAdmin';
update User_Table set AUTODISABLEINTERVAL = 0 where UserName = 'SysAdmin';
update USER_TABLE set USERPASSWORD = 'F6E839178611157BA182FBED1CAEF056' where
USERNAME = 'SysAdmin';
update User_Table set PASSWORDSETTIME='05/03/2008' where UserName='SysAdmin';
commit;
Hope this helps.
-Joe
-----------------------------------------
Thanks in advance!
Ignatius S
