SQL Data Classification for tables and their attributes

asked 2022-06-14T09:59:35.79+00:00
eric 41 Reputation points

Hi , As you know in the SQL data classification feature there are different security labels like "Public" , "General", "Confidential" etc and different types of information like "Credential", "Name", "Other" etc, I wonder is it possible to label a data table its as "Public" as its security label but identify parts of its attributes as "General" or "Confidential" ? Will this be possible? For example , label a "Fruits" table as Public , but within that table ,I label the attribute "Color of the fruit" as "Confidential" and its type of information as "Other".

  • Fruits Table : (Public)
    - Color of the fruit : (Other- Confidential)
    - fruit's size : (Other - General)

Thank you

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,472 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2022-06-15T09:15:21.587+00:00
    Seeya Xi-MSFT 12,511 Reputation points Microsoft Employee

    Hi @eric ,

    I wonder is it possible to label a data table its as "Public" as its security label but identify parts of its attributes as "General" or "Confidential" ?

    Yes. Here is my example:
    211622-image.png
    See this official document: https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and-classification?view=sql-server-ver16&tabs=t-sql
    Here is a picture in the above link which meet your assumption:
    211569-image.png

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.