How to reset lost password of superuser account

Document ID : KB000013255
Last Modified Date : 14/02/2018
Show Technical Document Details

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.


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

CA Release Automation 5.5.XCA Release Automation 6.X.XOracle Database Server 11g and 12c
  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: 
  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****