05-02-2008 09:55 PM
Is there a way to recover a lost CTM SysAdmin password? The customer is using CTM v8 on a Sun station.
Thanks in advance!
05-03-2008 07:07 AM
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
05-05-2008 01:30 PM
Thanks Joe,
I went through the steps you listed and it appearsd to take properly, but I still can't log into SysAdmin using Ctm123! as the password.
Can you verify the UserPassword string? I went though it 3 time, just to make sure I wasn't mis-typing anything.
Thanks!
-Randy
05-16-2008 03:56 PM
Just wanted to post a follow up. In addition to the login password, there were other things that weren't opperating properly on the box. We restarted the Sun station... and now the CTM password works! Go figure :)
01-28-2015 08:16 AM
I followed the SQL command sequence. Everything appeared to work correctly.
I was able to login using the SysAdmin username and new password. I tried to change the SysAdmin password and received a notice that I don't have permission to change my password.
What else needs to be done?
BTW, my system is hosted on RHEL, not SUN. My version is CPO 9.6.
02-10-2015 02:58 PM
I managed to change the SysAdmin password. After successfully changing the SysAdmin password and logging in, I created a SuperUser account for myself. Logged out and logged back in as my new account. I opened the Domain Explorer, then Administration, and Users. I edited the SysAdmin account password from there.
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