Re: Data masking for mysql

2014-04-16 Thread reena . kamboj
Client never give production db with sensitive data to oursourced dev team. But outsourced testing team need a clone of production db for testing. For that client can give a copy of production db with masked sensitive data. That's why data masking tool required. -Original Message- From:

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
data masking tool is like a layer between destination DB(production DB) and target DB(test DB). It does all the changes in target DB, so data never change in destination DB. -Original Message- From: "Peter Brawley" Sent: Tuesday, 15 April, 2014 10:12pm To: reena.kam...@jktech.com, "mysq

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
Actually data masking is a one time activity, so I need data masking tool. I do not need it again & again. -Original Message- From: "Jigal van Hemert" Sent: Tuesday, 15 April, 2014 3:43pm To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Hi, On 15-4-2014 11:03, reena.kam...

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
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. -Original Message- From: "Reindl Harald" Sent: Tuesday, 15 April, 2014 2:49pm To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Am 15.0

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
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-- xx5877) by using data masking. We can use any one data masking technique at DB le

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
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-- xx5877) by using data masking. We can use any one da

Data masking for mysql

2014-04-14 Thread reena . kamboj
, Reena Kamboj ** 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