SQL 2016 – Dynamic data masking

With SQL Server 2016 released you can now mask your data / columns in such a way that users with valid permissions can only see the
actual data whereas other will see he masked data as per the configuration. Download Script Here. DataMask

DDMask1

Create a user with Datareader permission and see the results after connecting from that user.

ddmask2

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *