Am 15.04.2014 12:37, schrieb reena.kam...@jktech.com: > It can be done by data masking tool itself. Its one time activity, I do not > need it again & again. Please suggest data masking tool link.
jesus christ there is not click here and be happy tool just write a small script to do this - that's what sysadmins get paied for how do you expect ready tool matching exact a single one-time-need? > -----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
signature.asc
Description: OpenPGP digital signature