Forum Discussion
Conditional dynamic data masking
Hi, thinking a customer table to query, is it possible to show/mask the customer name respect to the value of the customer type? Only for specific customer types the customer date have to be visible...
Hi, it seems that the dynamic data masking and the column-level security features don't allow to implement a conditional data masking respect to another column, isn't it?
Does it exist another manner to solve a such issue? Thanks
Hi pmscorca,
Perhaps you can take a look at the security policy, you can setting a condition on it to control the DDM effects:
CREATE SECURITY POLICY (Transact-SQL) - SQL Server | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi, it seems that using a security policy I couldn't satisfy the business requirement. Thanks