JADEĀ  Environment Development Ideas

Dynamic Data Masking

Dynamic data masking - limits sensitive data exposure by masking it to non-privileged users. It can be used to greatly simplify the design and coding of security in your application.

This is already available in MS SQL server.


Is it something that could benefit Jade, is this something that could be used at an application refresh level. IE when production data is copied into a Test application, key values automatically masked - accounts - phone numbers etc.

  • Phil Camp
  • May 5 2020
  • Future consideration (Long term)
  • Attach files
  • Ty Baen-Price commented
    20 May 21:33

    This is only really useful in SQL Server when you haven't created some kind of role-based privilege system, and you're allowing custom queries to be run. I don't think this really helps in Testing systems, as you still want real data - albeit obfuscated.