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 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