Changing masking policy without unsetting that masking policy

Question

Is it possible to alter an existing masking policy without unsetting this policy?

For example, I have a masking policy that is set to multiple columns. So, when I want to change the policy to include more roles, I have to first unset the policy from every column (which takes a lot of time).

score 3 · Accepted Answer · answered Nov 06 '20 at 20:49

3

Yes - just run an ALTER MASKING POLICY... command

answered Nov 06 '20 at 20:49

NickW

8,430
2
6
19

1

...as long as the data type of the masking policy output doesn't change. – Mike Walton Nov 07 '20 at 00:58

Changing masking policy without unsetting that masking policy

1 Answers1