pulumi-azure-native-kotlin/com.pulumi.azurenative.sql.kotlin/DataMaskingPolicy

DataMaskingPolicy

class DataMaskingPolicy : KotlinCustomResource

A database data masking policy. Uses Azure REST API version 2023-08-01. In version 2.x of the Azure Native provider, it used API version 2021-11-01. Other available API versions: 2014-04-01, 2021-11-01, 2022-02-01-preview, 2022-05-01-preview, 2022-08-01-preview, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview, 2024-05-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native sql [ApiVersion]. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.

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",
    });
});

package main
import (
	sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v3"
	"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
	})
}

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());
    }
}

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",
    });
});

package main
import (
	sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v3"
	"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
	})
}

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());
    }
}

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:sql:DataMaskingPolicy Default /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/dataMaskingPolicies/{dataMaskingPolicyName}

Properties

applicationPrincipals

val applicationPrincipals: Output<String>

The list of the application principals. This is a legacy parameter and is no longer used.

azureApiVersion

val azureApiVersion: Output<String>

The Azure API version of the resource.

dataMaskingState

val dataMaskingState: Output<String>

The state of the data masking policy.

exemptPrincipals

val exemptPrincipals: Output<String>?

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.