Hi,

On 15-4-2014 11:03, reena.kam...@jktech.com wrote:
The main reason for applying masking to a data field is to protect
data from external exposure. for example mobile no. is 9878415877,
digits can by shuffle(8987148577) or can replace with other
letter/number(first 6 digits replace with X-- xxxxxx5877) by using
data masking. We can use any one data masking technique to protect
our sensitive data from external exposure. I need a tool which will
mask data in existing mysql db.

You could create a VIEW on that table which contains processed columns. Use a special user for the application that has SELECT rights on the view but not on the table.

--
Kind regards / met vriendelijke groet,

Jigal van Hemert.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to