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.
-----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