How to change the User Name displayed in the Site Users tab in Site Admin

  • Questions
  • How to change the User Name displayed in the Site Users tab in Site Admin
Question ID: 106365
0
0

How do I go about changing the name that displays in the 'User Name' field in the 'Site Users' tab in Site Admin. I can select the field, but it won’t allow me to make any changes. How can this value be changed?

Marked as spam
Posted by (Questions: 217, Answers: 21)
Asked on September 4, 2015 3:39 pm
3 views
Answers (1)
0
Private answer

If you are using a MS SQL Server DB, access the Microsoft SQL Server Management Studio, expand 'qcsiteadmin_db', then the 'Tables' folder. Highlight the 'td.USERS' table, click the 'New Query' button then enter the following query and click the 'Execute' button:

UPDATE USERS
SET US_USERNAME = 'New Username'
WHERE US_USERNAME = 'Old Username';

Log back into the project and click the drop down for the 'Responsible Tester' field and verify that the change has taken place.

Marked as spam
Posted by (Questions: 2, Answers: 278)
Answered on September 4, 2015 3:41 pm