Search Documentation
< All Topics

Redacting an account with a subscription

Posted15 May 2024
Updated15 May 2024
ByAndrew
  1. In the portal, locate the account using the “Manage Member” option.
  2. Change the email in the portal to REDACTED-[DATE-YYYY-MM-DD]@REDACTED.com. e.g. [email protected]
  3. Copy the User UUID from the portal
  4. In the DB go to the user_information.email_changes table and find any records relating to the user and delete them, there will be at least one from the email address change you just made.
  5. In the CRM DB, go to the CCBillTransStats, EpochTransStats, VendoTransStats and VendoCancelledUsers tables and search for the original email address.
  6. Change the username and email address records to the email address created in step 2 above.
  7. Change the name, address and IP fields to REDACTED
  8. Check for any records in the old MembersTransactions table in the CRM DB and if there any, redact the data from those fields as well.
Table of Contents