Tuesday 27 June 2017

How to Reset Site Admin Password in HP ALM if you forgot the password


If you want to reset the site admin password then you need direct access to the database. In Oracle/MS-SQL Server it is the qcsiteadmin_db schema. Here is the thread that helps:


To do this, you will want the DBA to assist with this process. Here is what they need to do:
1) Open the USERS table in the qcsiteadmin_db schema
2) Search for the ID in the table and delete the encrypted password in the password field.
3) Login to Site Administration
4) Via Site Users tab find that ID and reset the password.

UPDATE td.USERS
 SET USER_PASSWORD = ''
 WHERE USER_NAME = 'YOUR_ALM_ADMIN_USER_NAME_HERE'
 

No comments:

Post a Comment