CODEWITHSUNDEEP
sql-server
Blue Clouds
Blue Clouds

Reputation: 8161

Azure SQL Server labeling vs Masking

If we label a column as part of 'Data Discovery & Classification' in SQL server, will it automatically do the masking or we have to separately mask it?

Upvotes: 1

Views: 47

Answers (1)

Venkataraman R
Venkataraman R

Reputation: 12969

SQL Server labeling is kind of a meta data, similar to extended properties. So, it does not automatically enable masking. More on Data Discovery & Classification

You can have a code, which reads sys.sensitivity_classifications and accordingly enable masking for the columns.

Upvotes: 2

Related Questions