تحرير

Set-AzSqlInstanceDatabaseSensitivityClassification

  • Reference
Module:
Az.Sql

Sets the information types and sensitivity labels of columns in the Azure SQL Managed Instance database.

Note

This is the previous version of our documentation. Please consult the most recent version for up-to-date information.

Syntax

Set-AzSqlInstanceDatabaseSensitivityClassification
   -ClassificationObject <ManagedDatabaseSensitivityClassificationModel>
   [-PassThru]
   [-AsJob]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Set-AzSqlInstanceDatabaseSensitivityClassification
   [-SensitivityLabel <String>]
   [-InformationType <String>]
   [-ResourceGroupName] <String>
   [-InstanceName] <String>
   [-DatabaseName] <String>
   -SchemaName <String>
   -TableName <String>
   -ColumnName <String>
   [-PassThru]
   [-AsJob]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]
Set-AzSqlInstanceDatabaseSensitivityClassification
   [-SensitivityLabel <String>]
   [-InformationType <String>]
   -DatabaseObject <AzureSqlManagedDatabaseModel>
   -SchemaName <String>
   -TableName <String>
   -ColumnName <String>
   [-PassThru]
   [-AsJob]
   [-DefaultProfile <IAzureContextContainer>]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

The Set-AzSqlInstanceDatabaseSensitivityClassification cmdlet sets the information types and sensitivity labels of columns in the Azure SQL Managed Instance database.

Examples

Example 1: Set information type and sensitivity label of a column in an Azure SQL Managed Instance database.

PS C:\> Set-AzSqlInstanceDatabaseSensitivityClassification -ResourceGroupName resourceGroup -InstanceName managedInstance -DatabaseName database -SchemaName schema -TableName table -ColumnName column -InformationType informationType -SensitivityLabel label
PS C:\> Get-AzSqlInstanceDatabaseSensitivityRecommendation -ResourceGroupName resourceGroup -InstanceName managedInstance -DatabaseName database | Set-AzSqlInstanceDatabaseSensitivityClassification

Example 3: Set information type and sensitivity label of a column in an Azure SQL Managed Instance database, using piping.

PS C:\> Get-AzSqlInstanceDatabase -ResourceGroupName resourceGroup -InstanceName managedInstance -DatabaseName database | Set-AzSqlInstanceDatabaseSensitivityClassification -SchemaName schema -TableName table -ColumnName column -InformationType informationType -SensitivityLabel label

Parameters

-AsJob

Run cmdlet in the background

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ClassificationObject

An object representing a SQL Managed Instance Database Sensitivity Classification.

Type:ManagedDatabaseSensitivityClassificationModel
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-ColumnName

Name of column.

Type:String
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-DatabaseName

The name of the Azure SQL Managed Instance database.

Type:String
Position:2
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-DatabaseObject

The Azure SQL Managed Instance database object.

Type:AzureSqlManagedDatabaseModel
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-DefaultProfile

The credentials, account, tenant, and subscription used for communication with Azure.

Type:IAzureContextContainer
Aliases:AzContext, AzureRmContext, AzureCredential
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-InformationType

A name that describes the information type of the data stored in the column.

Type:String
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-InstanceName

Azure SQL Managed Instance name.

Type:String
Position:1
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-PassThru

Specifies whether to output the sensitivity classification model at end of cmdlet execution

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ResourceGroupName

The name of the resource group.

Type:String
Position:0
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-SchemaName

Name of schema.

Type:String
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-SensitivityLabel

A name that describes the sensitivity of the data stored in the column.

Type:String
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-TableName

Name of table.

Type:String
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Inputs

ManagedDatabaseSensitivityClassificationModel

Outputs

Boolean