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.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: