DDM Restriction


  • Hi ,

    Can some one furnish me the details of 

      "Explain the usage of column types where ‘Dynamic Data Masking’ (DDM) rule cannot be applied"

    also any URL to refer the above statement 



    Tuesday, January 3, 2017 6:53 AM

All replies

  • Take a look at the following link, you'll find the restrictions under the topic of "Limitations and Restrictions" | | @EkremOnsoy

    Tuesday, January 3, 2017 7:34 AM
  • Hi Hemadribabu,

    Dynamic data masking provides a simple way to implement obfuscation of private data, it is not true encryption and that the data cannot be protected in all scenarios. The limitation is designed for better security.

    You can refer to this article: Understand the Limitations of SQL Server Dynamic Data Masking at .

    If you have any other questions, please let me know.

    Best Regards,

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Friday, January 6, 2017 8:04 AM