azure sql dynamic data masking multiple policies or groups

Question

I'm trying to use the Dynamic data masking in Azure SQL database. What I'm trying to achieve is that I want to have multiple masking policies for multiple AAD groups.

For example a table has 4 columns and I have 3 AAD groups:

• Group 1 should see data from column 1 and 2 but mask column 3 and 4

• Group 2 should see data from column 1,2 and 3 but mask column 4

• Group 3 should see all data

I'm not sure if this is even possible at all. Is there anyone who can help me?

Kind regards

Answer 1

Seems there is no granularity for the UNMASK permission in SQL Server, either we can see all masked data as masked or unmasked, depends on whether they have UNMASK granted.

Check this link