07-28-2010 02:39 AM
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
Solved! Go to Solution.
07-29-2010 01:16 PM
07-29-2010 01:16 PM
07-29-2010 08:36 PM
thanks for the reply....
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide