Search code examples
mysqlsecurityrandomdata-masking

How to mask information in mysql

Let's assume that a database dump is made "production for the bank" development "where developers will work and I do not want developers to see sensitive information like social security number, credit card, phone, etc ... like could I mask this data in mysql?

Example

Original Phone: 1111-1111

Masked with X Phone: 11XX-XXXX

Masked randomly Phone: 5254-7293

note: the database was written in Portuguese (my language)

SELECT

diagram

Solution

  • There is a free version of DataVeil data masking software that you can use. It's similar to the software you ask about in your question's comments. There are also demo videos on the site. Disclaimer: I work for DataVeil.