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).
Yes - just run an ALTER MASKING POLICY... command
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With