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.