On 2014-04-15 5:37 AM, reena.kam...@jktech.com wrote:
It can be done by data masking tool itself. Its one time activity, I do not need it
again & again.
Rilly? If that's so, the data will never be accessed.
'PB
Please suggest data masking tool link.
-----Original Message-----
From: "Reindl Harald" <h.rei...@thelounge.net>
Sent: Tuesday, 15 April, 2014 2:49pm
To: mysql@lists.mysql.com
Subject: Re: Data masking for mysql
Am 15.04.2014 11:08, schrieb reena.kam...@jktech.com:
Yes, we can do it at application level and database level as well.
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 at DB level to
protect our sensitive data from external exposure.
I have sensitive data in existing mysql db. I need to do data masking at DB
level.
If any tools available for the same please respond
write a simle PHP script iterating the records, read the column, mask
the data and write it back - again: that's not the business of the db-layer
**********************************************************************************************************************
<img src='http://jktech.com//cms/website_files/image001.jpg' />
<p>
CONFIDENTIALITY. This e-mail and any attachments are confidential and may also
be privileged. If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to another person, use it for any
purpose, or store or copy the information in any medium. Any views expressed in
this message are those of the individual sender, except where the sender
specifically states them to be the views of JK Technosoft Ltd. If you have
received this e-mail in error please immediately notify the person who has sent
this email to you with copy to administra...@jktech.com
</p>
**********************************************************************************************************************
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
