List:General Discussion« Previous MessageNext Message »
From:reena.kamboj Date:April 16 2014 6:57am
Subject:Re: Data masking for mysql
View as plain text  
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" <jigal@stripped>
Sent: Wednesday, 16 April, 2014 11:56am
To: mysql@stripped
Subject: Re: Data masking for mysql

Hi,

On 15-4-2014 18:42, Peter Brawley wrote:
> 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.

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