Which of the following are characteristics of Dynamic Data Masking?
A masking policy may be applied to matching columns in multiple tables. It may also be assigned to an external table’s VALUE column with an ALTER TABLE … ALTER COLUMN statement; the policy protecting that column must have the VARIANT data type. Unmasked query results depend on the policy conditions and active role, rather than on who created the policy.
VALUE
ALTER TABLE … ALTER COLUMN
VARIANT
Community Discussion