SQL Server 2019 Data Classification

sakuraime 2,321 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,758 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    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 21,096 Reputation points Microsoft Vendor
    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.