1032924 - Obscure email addresses on staging for One and Done

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Rebecca Billings [:rbillings]]

The One and Done staging instance was updated with production data. I would like all of the email address information within the django admin to be obscured- as it contains private data.

Comment 1

[Rebecca Billings [:rbillings]]

Production site = https://oneanddone.mozilla.org/en-US/

Bob- what is the name of the database?

Comment 2

[Bob Silverberg [:bsilverberg]]

When I imported the production data into the staging database I imported all of the task data, but only imported a handful of users. They were all mozilla.com email addresses, and were the first bunch of users in the table, therefore all employees who were originally set up for testing. This means that I didn't import any users with email addresses that shouldn't be visible to administrators, so I think this is a non-issue. Furthermore, the only place that email addresses are stored is in the User table, and that is used for login, so if we were to make any changes to the email addresses in that table, none of those users would be able to login anymore.

So while it would definitely be nice to be able to take a dump from production in the future and import the whole thing with sensitive information scrubbed, I don't think this is something we need to do now for the staging database. Please feel free to correct me if I am wrong.

Oh, and in case I am wrong, and you need it, the name of the database is: d855962562d30496ba5d79b0cdef8ea79

Comment 3

[Sheeri Cabral [:sheeri]]

OK, so is there any action on this?

Comment 4

[Rebecca Billings [:rbillings]]

Marking as resolved as it's much lower risk than I thought- thanks to a very smart implementation. No action is needed.