Data Masking Policy
Represents a database data masking policy. API Version: 2014-04-01.
Example Usage
Create or update data masking policy max
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var dataMaskingPolicy = new AzureNative.Sql.DataMaskingPolicy("dataMaskingPolicy", new()
{
DataMaskingPolicyName = "Default",
DataMaskingState = AzureNative.Sql.DataMaskingState.Enabled,
DatabaseName = "sqlcrudtest-331",
ExemptPrincipals = "testuser;",
ResourceGroupName = "sqlcrudtest-6852",
ServerName = "sqlcrudtest-2080",
});
});
Content copied to clipboard
package main
import (
sql "github.com/pulumi/pulumi-azure-native-sdk/sql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sql.NewDataMaskingPolicy(ctx, "dataMaskingPolicy", &sql.DataMaskingPolicyArgs{
DataMaskingPolicyName: pulumi.String("Default"),
DataMaskingState: sql.DataMaskingStateEnabled,
DatabaseName: pulumi.String("sqlcrudtest-331"),
ExemptPrincipals: pulumi.String("testuser;"),
ResourceGroupName: pulumi.String("sqlcrudtest-6852"),
ServerName: pulumi.String("sqlcrudtest-2080"),
})
if err != nil {
return err
}
return nil
})
}
Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.DataMaskingPolicy;
import com.pulumi.azurenative.sql.DataMaskingPolicyArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var dataMaskingPolicy = new DataMaskingPolicy("dataMaskingPolicy", DataMaskingPolicyArgs.builder()
.dataMaskingPolicyName("Default")
.dataMaskingState("Enabled")
.databaseName("sqlcrudtest-331")
.exemptPrincipals("testuser;")
.resourceGroupName("sqlcrudtest-6852")
.serverName("sqlcrudtest-2080")
.build());
}
}
Content copied to clipboard
Create or update data masking policy min
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var dataMaskingPolicy = new AzureNative.Sql.DataMaskingPolicy("dataMaskingPolicy", new()
{
DataMaskingPolicyName = "Default",
DataMaskingState = AzureNative.Sql.DataMaskingState.Enabled,
DatabaseName = "sqlcrudtest-331",
ResourceGroupName = "sqlcrudtest-6852",
ServerName = "sqlcrudtest-2080",
});
});
Content copied to clipboard
package main
import (
sql "github.com/pulumi/pulumi-azure-native-sdk/sql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sql.NewDataMaskingPolicy(ctx, "dataMaskingPolicy", &sql.DataMaskingPolicyArgs{
DataMaskingPolicyName: pulumi.String("Default"),
DataMaskingState: sql.DataMaskingStateEnabled,
DatabaseName: pulumi.String("sqlcrudtest-331"),
ResourceGroupName: pulumi.String("sqlcrudtest-6852"),
ServerName: pulumi.String("sqlcrudtest-2080"),
})
if err != nil {
return err
}
return nil
})
}
Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.DataMaskingPolicy;
import com.pulumi.azurenative.sql.DataMaskingPolicyArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var dataMaskingPolicy = new DataMaskingPolicy("dataMaskingPolicy", DataMaskingPolicyArgs.builder()
.dataMaskingPolicyName("Default")
.dataMaskingState("Enabled")
.databaseName("sqlcrudtest-331")
.resourceGroupName("sqlcrudtest-6852")
.serverName("sqlcrudtest-2080")
.build());
}
}
Content copied to clipboard
Import
An existing resource can be imported using its type token, name, and identifier, e.g.
$ pulumi import azure-native:sql:DataMaskingPolicy Default /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-331/dataMaskingPolicies/Default
Content copied to clipboard
Properties
Link copied to clipboard
The list of the application principals. This is a legacy parameter and is no longer used.
Link copied to clipboard
The state of the data masking policy.
Link copied to clipboard
The list of the exempt principals. Specifies the semicolon-separated list of database users for which the data masking policy does not apply. The specified users receive data results without masking for all of the database queries.
Link copied to clipboard
The masking level. This is a legacy parameter and is no longer used.
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard