Knowledge Base Article

> Knowledge Base > Spira Platform

Sometimes you create user accounts in SpiraTeam for real users to login and test the system. For example you may have a UAT (user acceptance testing) phase, or a crowdsourced testing event (like our Software Testing Bowl). You then want to turn over the data to a third party supplier, but you need to anonymize the users' personal information

Anonymizing the User Profiles

Inside SpiraTeam you have the list of users stored, together with their first name, last name, email address, and login. Depending on the format you used, all of these could be considered personal data from a GDPR (or HIPAA if in the USA) standpoint.

The following SQL will change all the user profiles to an anonymous (userX) format based on their ID. It will leave the administrator account untouched:

UPDATE TST_USER
SET
	USER_NAME = 'user' + CAST(USER_ID AS NVARCHAR),
	EMAIL_ADDRESS = 'user' + CAST(USER_ID AS NVARCHAR) + '@mycompany.com'
WHERE USER_ID <> 1

UPDATE TST_USER_PROFILE
SET
	FIRST_NAME = 'user' + CAST(USER_ID AS NVARCHAR),
	LAST_NAME = 'user' + CAST(USER_ID AS NVARCHAR),
	MIDDLE_INITIAL = NULL
WHERE USER_ID <> 1

I Am Cloud Hosted, What Do I Do?

If you are cloud hosted by Inflectra, then just log a support ticket and we can run this script for you.

Article Info
  • Last Updated: 11/2/2018
  • Article ID: KB402
  • Views: 63