تحرير

Enable-AzSqlInstanceDatabaseSensitivityRecommendation

  • Reference
Module:
Az.Sql

Enables sensitivity recommendations on columns (recommendations are enabled by default on all 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

Enable-AzSqlInstanceDatabaseSensitivityRecommendation
      -InputObject <ManagedDatabaseSensitivityClassificationModel>
      [-PassThru]
      [-AsJob]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]
Enable-AzSqlInstanceDatabaseSensitivityRecommendation
      [-ResourceGroupName] <String>
      [-InstanceName] <String>
      [-DatabaseName] <String>
      -SchemaName <String>
      -TableName <String>
      -ColumnName <String>
      [-PassThru]
      [-AsJob]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]
Enable-AzSqlInstanceDatabaseSensitivityRecommendation
      -DatabaseObject <AzureSqlManagedDatabaseModel>
      -SchemaName <String>
      -TableName <String>
      -ColumnName <String>
      [-PassThru]
      [-AsJob]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Description

The Enable-AzSqlInstanceDatabaseSensitivityRecommendation cmdlet enables sensitivity recommendations on columns in the Azure SQL Managed Instance database.

Examples

Example 1: Enable sensitivity recommendations on a given column in an Azure SQL Managed Instance database.

PS C:\> Enable-AzSqlInstanceDatabaseSensitivityRecommendation -ResourceGroupName resourceGroup -InstanceName managedInstance -DatabaseName database -SchemaName schema -TableName table -ColumnName column

Example 2: Enable sensitivity recommendations on a given column in an Azure SQL Managed Instance database with Piping.

PS C:\> Get-AzSqlInstanceDatabase -ResourceGroupName resourceGroup -InstanceName managedInstance -Name database | Remove-AzSqlInstanceDatabaseSensitivityClassification -SchemaName schema -TableName table -ColumnName column

Parameters

-AsJob

Run cmdlet in the background

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
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
-InputObject

An object representing a SQL Managed Instance Database Sensitivity Classification.

Type:ManagedDatabaseSensitivityClassificationModel
Aliases:ClassificationObject
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
-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