List:General Discussion« Previous MessageNext Message »
From:reena.kamboj Date:April 16 2014 4:40am
Subject:Re: Data masking for mysql
View as plain text  
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.brawley@stripped>
Sent: Tuesday, 15 April, 2014 10:12pm
To: reena.kamboj@stripped, "mysql@stripped" <mysql@stripped>
Subject: Re: Data masking for mysql

On 2014-04-15 5:37 AM, reena.kamboj@stripped 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.reindl@stripped>
> Sent: Tuesday, 15 April, 2014 2:49pm
> To: mysql@stripped
> Subject: Re: Data masking for mysql
>
>
>
> Am 15.04.2014 11:08, schrieb reena.kamboj@stripped:
>> 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
>
>
>
>
> **********************************************************************************************************************
> <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 administrator@stripped
> </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 administrator@stripped
</p>
**********************************************************************************************************************

Thread
Data masking for mysql reena.kamboj15 Apr 2014
  • Re: Data masking for mysqlReindl Harald15 Apr 2014
    • Re: Data masking for mysqlreena.kamboj15 Apr 2014
      • Re: Data masking for mysqlJigal van Hemert15 Apr 2014
        • Re: Data masking for mysqlreena.kamboj15 Apr 2014
          • Re: Data masking for mysqlJigal van Hemert15 Apr 2014
  • Re: Data masking for mysqlManuel Arostegui15 Apr 2014
    • Re: Data masking for mysqlreena.kamboj15 Apr 2014
      • Re: Data masking for mysqlReindl Harald15 Apr 2014
        • Re: Data masking for mysqlreena.kamboj15 Apr 2014
          • Re: Data masking for mysqlReindl Harald15 Apr 2014
          • Re: Data masking for mysqlPeter Brawley15 Apr 2014
            • Re: Data masking for mysqlreena.kamboj16 Apr 2014
            • Re: Data masking for mysqlJigal van Hemert16 Apr 2014
              • Re: Data masking for mysqlreena.kamboj16 Apr 2014
                • Re: Data masking for mysqlshawn l.green16 Apr 2014
  • Re: Data masking for mysqlmisiaq18 Apr 2014