Re: Data masking for mysql

2014-04-17 Thread misiaq
Hi, If you don't care to much how the data look like - just run once of update and replace it with some random stings. If you do however, and you still want to telephone numbers looks like telephone numbers, what I can suggest is to use a data generator like this one http://www.generatedata.com

Re: Data masking for mysql

2014-04-16 Thread shawn l.green
. That's why data masking tool required. -Original Message- From: "Jigal van Hemert" Sent: Wednesday, 16 April, 2014 11:56am To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Hi, On 15-4-2014 18:42, Peter Brawley wrote: On 2014-04-15 5:37 AM, reena.kam...@jktech

Re: Data masking for mysql

2014-04-16 Thread reena . kamboj
From: "Jigal van Hemert" Sent: Wednesday, 16 April, 2014 11:56am To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Hi, On 15-4-2014 18:42, Peter Brawley wrote: > On 2014-04-15 5:37 AM, reena.kam...@jktech.com wrote: >> It can be done by data masking tool itself.

Re: Data masking for mysql

2014-04-15 Thread Jigal van Hemert
Hi, On 15-4-2014 18:42, Peter Brawley wrote: 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. I'm starting to think that a concept ha

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
jktech.com, "mysql@lists.mysql.com" Subject: Re: Data masking for mysql 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 ac

Re: Data masking for mysql

2014-04-15 Thread Peter Brawley
sage- From: "Reindl Harald" 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 987841587

Re: Data masking for mysql

2014-04-15 Thread Jigal van Hemert
Hi, On 15-4-2014 12:36, reena.kam...@jktech.com wrote: Actually data masking is a one time activity, so I need data masking tool. I do not need it again & again. So you basically want to replace the data with modified data. You can do that with an update query [1]. There are all kinds of func

Re: Data masking for mysql

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

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

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 f

Re: Data masking for mysql

2014-04-15 Thread Jigal van Hemert
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-- x

Re: Data masking for mysql

2014-04-15 Thread Reindl Harald
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-- > xx5877) by using d

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
reena.kam...@jktech.com Cc: "mysql@lists.mysql.com" Subject: Re: Data masking for mysql 2014-04-15 8:52 GMT+02:00 : > Hi, > > I need to do data masking to sensitive data exists in mysql db. is there > any data masking tool available for mysql with linux platform. >

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
data masking technique to protect our sensitive data from external exposure. I need a tool which will mask data in existing mysql db. -Original Message- From: "Reindl Harald" Sent: Tuesday, 15 April, 2014 1:51pm To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Am

Re: Data masking for mysql

2014-04-15 Thread Manuel Arostegui
2014-04-15 8:52 GMT+02:00 : > Hi, > > I need to do data masking to sensitive data exists in mysql db. is there > any data masking tool available for mysql with linux platform. > if yes... please provide the links. > else... please suggest other alternatives for this requirement. > > I look forward

Re: Data masking for mysql

2014-04-15 Thread Reindl Harald
Am 15.04.2014 08:52, schrieb reena.kam...@jktech.com: > I need to do data masking to sensitive data exists in mysql db. is there any > data masking tool available for mysql with linux platform. > if yes... please provide the links. > else... please suggest other alternatives for this requirement