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.

https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15

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.