Sometimes you want to allow somebody to read data inside a database, yet at the same time you do not want him or her to read more sensitive data (such as birth date, addresses, or surnames). In Azure SQL, there is a feature for that named Dynamic Data Masking:
There are two ways to add a mask—either use the recommendation or click on the + Add Mask button to add it manually:
What you will have to do select Schema, Table, Column, and the Mask field format—once you configure these and save the rule, users who are not administrators ...