Re: Data masking for mysql
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: Jigal van Hemert ji...@xs4all.nl 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. 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 has been made that includes a database with the original data, a copy with the masked data and then there just needs to be a tool that copies the data and modifies (masks) some fields. Whatever solution we come up with (views, db copy with an update query that modifies the data, ...) it will not be accepted unless it fits the original concept. Most likely the client came up with the concept and then this outsourced development team doesn't dare to suggest that a different concept is probably a better way to reach the goal. But, I may be wrong here :-) -- 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 ** 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
Data masking for mysql
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 to hearing from you. With best regards, Reena Kamboj ** 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
Re: Data masking for mysql
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 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 h.rei...@thelounge.net Sent: Tuesday, 15 April, 2014 1:51pm To: mysql@lists.mysql.com Subject: Re: Data masking for mysql 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 what is data masking? if you mean encryption you need to do that in the application because transparent encryption and decryption in the database layer makes little sense ** 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
Re: Data masking for mysql
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 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. -Original Message- From: Manuel Arostegui man...@tuenti.com Sent: Tuesday, 15 April, 2014 2:02pm To: reena.kam...@jktech.com Cc: mysql@lists.mysql.com mysql@lists.mysql.com Subject: Re: Data masking for mysql 2014-04-15 8:52 GMT+02:00 reena.kam...@jktech.com: 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 to hearing from you. I don't think there's a generic tool for it. It depends on your data, format etc. ie: it's not the same a credit card record than an email or a phone number one. It depends on your data, so you might want to do it from an application level. Good luck Manuel. ** 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
Re: Data masking for mysql
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 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-- xx5877) 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
Re: Data masking for mysql
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 ji...@xs4all.nl 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...@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-- xx5877) 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 ** 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
Re: Data masking for mysql
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 peter.braw...@earthlink.net Sent: Tuesday, 15 April, 2014 10:12pm To: reena.kam...@jktech.com, mysql@lists.mysql.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 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-- xx5877) 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 ** 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