Get-AzSqlDatabaseSensitivityClassification
Mendapatkan jenis informasi saat ini dan label sensitivitas kolom dalam database.
Sintaks
Get-AzSqlDatabaseSensitivityClassification
-DatabaseObject <AzureSqlDatabaseModel>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlDatabaseSensitivityClassification
[-ResourceGroupName] <String>
[-ServerName] <String>
[-DatabaseName] <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlDatabaseSensitivityClassification
[-ResourceGroupName] <String>
[-ServerName] <String>
[-DatabaseName] <String>
-SchemaName <String>
-TableName <String>
-ColumnName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSqlDatabaseSensitivityClassification
-DatabaseObject <AzureSqlDatabaseModel>
-SchemaName <String>
-TableName <String>
-ColumnName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Deskripsi
Cmdlet Get-AzSqlDatabaseSensitivityClassification mengembalikan jenis informasi saat ini dan label sensitivitas kolom dalam database Azure SQL.
Contoh
Contoh 1: Dapatkan jenis informasi saat ini dan label sensitivitas Azure SQL Database.
Get-AzSqlDatabaseSensitivityClassification -ResourceGroupName resourceGroup -ServerName server -DatabaseName database
ResourceGroupName : resourceGroup
ServerName : server
DatabaseName : database
SensitivityLabels : {{
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailBody,
InformationType: Contact Info
}, {
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailSubject,
SensitivityLabel: Confidential,
Rank: Medium
}, {
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Contoh 2: Dapatkan jenis informasi saat ini dan label sensitivitas Azure SQL Database dengan Piping.
Get-AzSqlDatabase -ResourceGroupName resourceGroup -ServerName server -DatabaseName database | Get-AzSqlDatabaseSensitivityClassification
ResourceGroupName : resourceGroup
ServerName : server
DatabaseName : database
SensitivityLabels : {{
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailBody,
InformationType: Contact Info
}, {
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailSubject,
SensitivityLabel: Confidential,
Rank: Medium
}, {
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Contoh 3: Dapatkan jenis informasi saat ini dan label sensitivitas kolom tertentu dari Azure SQL Database.
Get-AzSqlDatabaseSensitivityClassification -ResourceGroupName resourceGroup -ServerName server -DatabaseName database -SchemaName dbo -TableName EMailLog -ColumnName BounceEmailSubject
ResourceGroupName : resourceGroup
ServerName : server
DatabaseName : database
SensitivityLabels : {{
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Contoh 4: Dapatkan jenis informasi saat ini dan label sensitivitas kolom tertentu dari Azure SQL Database menggunakan Piping.
Get-AzSqlDatabase -ResourceGroupName resourceGroup -ServerName server -DatabaseName database | Get-AzSqlDatabaseSensitivityClassification -SchemaName dbo -TableName EMailLog -ColumnName BounceEmailSubject
ResourceGroupName : resourceGroup
ServerName : server
DatabaseName : database
SensitivityLabels : {{
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Parameter
-AsJob
Jalankan cmdlet di latar belakang
Jenis: | SwitchParameter |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-ColumnName
Nama kolom.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-DatabaseName
Nama database Azure SQL.
Jenis: | String |
Position: | 2 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-DatabaseObject
Objek database SQL.
Jenis: | AzureSqlDatabaseModel |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-DefaultProfile
Kredensial, akun, penyewa, dan langganan yang digunakan untuk komunikasi dengan Azure.
Jenis: | IAzureContextContainer |
Alias: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Nilai default: | None |
Diperlukan: | False |
Terima input alur: | False |
Terima karakter wildcard: | False |
-ResourceGroupName
Nama grup sumber daya.
Jenis: | String |
Position: | 0 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-SchemaName
Nama skema.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-ServerName
Nama server SQL.
Jenis: | String |
Position: | 1 |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
-TableName
Nama tabel.
Jenis: | String |
Position: | Named |
Nilai default: | None |
Diperlukan: | True |
Terima input alur: | True |
Terima karakter wildcard: | False |
Input
Output
SqlDatabaseSensitivityClassificationModel