mardi 18 septembre 2018

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




Aucun commentaire:

Enregistrer un commentaire