Share via

SQL Server 2019 Data Classification

sakuraime 2,341 Reputation points
2021-07-23T06:39:20.697+00:00

Are there any way we can customize the LABEL and also the INFORMATION_TYPE ?

Like make a label : COMPANYA_CONFIDENTIAL and INFORMATION_TYPE COMPANYA_INFOTYPEA

and in the JSON (Information Protection Policy) , which can reflect the new label and information_type .
and we can further customize the our own PATTERN which match to the above classification. ? Thanks

SQL Server Other

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-07-23T08:24:39.947+00:00

    Hi @sakuraime ,

    Did you mean using below T-SQL add sensitivity classification in SQL Server 2019? If so , the answer is no. We can’t customize these. 

    ADD SENSITIVITY CLASSIFICATION TO [Object names]  
WITH (LABEL = [Label type], INFORMATION_TYPE = [Information Type]);

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

  2. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-07-26T02:37:09.807+00:00

    Hi @sakuraime ,

    Suggest you using below T-SQL to check SENSITIVITY CLASSIFICATION that you added.

    Select OBJECT_NAME(major_id) as [Object Name],  
label,information_type from sys.sensitivity_classifications

    > however when doing the following to export the json , LABELTESTING and INFORMATIONTYPETESTING is not there .

    Export Information Protection Policy download the default policy. Customize the information protection policy that applies to Azure only. Refer to this MS document.

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.