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

Hi,

On 15-4-2014 11:03, reena.kamboj@stripped 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-- xxxxxx5877) 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 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