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

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: 238, Answers: 31)
Asked on September 4, 2015 3:39 pm
20 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: 299)
Answered on September 4, 2015 3:41 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top