List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:April 15 2014 10:13am
Subject:Re: Data masking for mysql
View as plain text  
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.
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