Making dynamic data masking conditional

Question

My question may not be valid but is there any way to switch off dynamic data masking in runtime. I want to use same user for updating records.
I want to use on conditional basis. I need to select unmasked records for update & masked data for report. I this possible with same SQL user?

Answer 1

Hi @hriday sharma ,

> My question may not be valid but is there any way to switch off dynamic data masking in runtime.

No, you can’t.

Creating a mask on a column does not prevent updates to that column. So although users receive masked data when querying the masked column, the same users can update the data if they have write permissions. A proper access control policy should still be used to limit update permissions.

Please refer to Dynamic Data Masking.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.

Answer 2

No, because data masking is a security feature. That is, if you don't have the permission, you cannot see what is behind that data mask.