How to reset lost password of superuser account

Document ID:  TEC1513031
Last Modified Date:  08/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Release Automation

Releases

  • CA Release Automation:Release:6.0
  • CA Release Automation:Release:6.1
  • CA Release Automation:Release:6.2
  • CA Release Automation:Release:6.3
  • CA Release Automation:Release:5.5.2

Components

  • CA LISA RELEASE AUTOMATION CORE:RACORE
Introduction:

The ‘Superuser’ account is the default admin account that comes by default with Release Automation. 

 

If the password was changed and you cannot login, you can reset the password to the default password to login temporarily using the procedure below mentioned.

Question:

How to reset the lost password of superuser account in CA Release Automation 

Environment:
CA Release Automation 5.5.X CA Release Automation 6.X.X Oracle Database Server 11g and 12c
Answer:
  1. Connect to the Release Automation Database and run the below query

    Select * from users where username='superuser' 
  2. The default password for the 'superuser' account is 'suser' and it should be encrypted with the following value in the query result: 
    '5c3bfa2dc1f6724af518ca12fdbaa9d0c21e2d26389598c578e163ad9ec9c14339adb44065db1518'.
  3. If it was changed and you want to reset it, update the field with the above value using the query below and commit the database changes.

    Update users set password='5c3bfa2dc1f6724af518ca12fdbaa9d0c21e2d26389598c578e163ad9ec9c14339adb44065db1518' where username='superuser' ;

    Note: The above statements are for Oracle Database Server and need to be translated to the syntax used by the appropriate database.

 

****Important: It is recommended to take a backup of the database before running any update query****

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >