Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

CTM SysAdmin Password

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

Everyone's tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: CTM SysAdmin Password

Yes.  It will work for 9.0.
2 REPLIES
Cisco Employee

Re: CTM SysAdmin Password

Yes.  It will work for 9.0.
New Member

Re: CTM SysAdmin Password

thanks for the reply....

387
Views
0
Helpful
2
Replies
CreatePlease to create content