pulumi-azure-native-kotlin/com.pulumi.azurenative.security.kotlin/SqlVulnerabilityAssessmentBaselineRule

SqlVulnerabilityAssessmentBaselineRule

class SqlVulnerabilityAssessmentBaselineRule : KotlinCustomResource

Rule results. Azure REST API version: 2023-02-01-preview. Prior API version in Azure Native 1.x: 2020-07-01-preview.

Example Usage

Create a baseline

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var sqlVulnerabilityAssessmentBaselineRule = new AzureNative.Security.SqlVulnerabilityAssessmentBaselineRule("sqlVulnerabilityAssessmentBaselineRule", new()
    {
        LatestScan = false,
        ResourceId = "subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master",
        Results = new[]
        {
            new[]
            {
                "userA",
                "SELECT",
            },
            new[]
            {
                "userB",
                "SELECT",
            },
        },
        RuleId = "VA1234",
        WorkspaceId = "55555555-6666-7777-8888-999999999999",
    });
});

package main
import (
	"github.com/pulumi/pulumi-azure-native-sdk/security/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := security.NewSqlVulnerabilityAssessmentBaselineRule(ctx, "sqlVulnerabilityAssessmentBaselineRule", &security.SqlVulnerabilityAssessmentBaselineRuleArgs{
			LatestScan: pulumi.Bool(false),
			ResourceId: pulumi.String("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master"),
			Results: pulumi.StringArrayArray{
				pulumi.StringArray{
					pulumi.String("userA"),
					pulumi.String("SELECT"),
				},
				pulumi.StringArray{
					pulumi.String("userB"),
					pulumi.String("SELECT"),
				},
			},
			RuleId:      pulumi.String("VA1234"),
			WorkspaceId: pulumi.String("55555555-6666-7777-8888-999999999999"),
		})
		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.security.SqlVulnerabilityAssessmentBaselineRule;
import com.pulumi.azurenative.security.SqlVulnerabilityAssessmentBaselineRuleArgs;
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 sqlVulnerabilityAssessmentBaselineRule = new SqlVulnerabilityAssessmentBaselineRule("sqlVulnerabilityAssessmentBaselineRule", SqlVulnerabilityAssessmentBaselineRuleArgs.builder()
            .latestScan(false)
            .resourceId("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master")
            .results(
                    "userA",
                    "SELECT",
                    "userB",
                    "SELECT")
            .ruleId("VA1234")
            .workspaceId("55555555-6666-7777-8888-999999999999")
            .build());
    }
}

Create a baseline using the latest scan results

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var sqlVulnerabilityAssessmentBaselineRule = new AzureNative.Security.SqlVulnerabilityAssessmentBaselineRule("sqlVulnerabilityAssessmentBaselineRule", new()
    {
        LatestScan = true,
        ResourceId = "subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master",
        Results = new[] {},
        RuleId = "VA1234",
        WorkspaceId = "55555555-6666-7777-8888-999999999999",
    });
});

package main
import (
	"github.com/pulumi/pulumi-azure-native-sdk/security/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := security.NewSqlVulnerabilityAssessmentBaselineRule(ctx, "sqlVulnerabilityAssessmentBaselineRule", &security.SqlVulnerabilityAssessmentBaselineRuleArgs{
			LatestScan:  pulumi.Bool(true),
			ResourceId:  pulumi.String("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master"),
			Results:     pulumi.StringArrayArray{},
			RuleId:      pulumi.String("VA1234"),
			WorkspaceId: pulumi.String("55555555-6666-7777-8888-999999999999"),
		})
		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.security.SqlVulnerabilityAssessmentBaselineRule;
import com.pulumi.azurenative.security.SqlVulnerabilityAssessmentBaselineRuleArgs;
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 sqlVulnerabilityAssessmentBaselineRule = new SqlVulnerabilityAssessmentBaselineRule("sqlVulnerabilityAssessmentBaselineRule", SqlVulnerabilityAssessmentBaselineRuleArgs.builder()
            .latestScan(true)
            .resourceId("subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Rg/providers/Microsoft.HybridCompute/machines/MyMachine/sqlServers/server1/databases/master")
            .results()
            .ruleId("VA1234")
            .workspaceId("55555555-6666-7777-8888-999999999999")
            .build());
    }
}

Import

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

$ pulumi import azure-native:security:SqlVulnerabilityAssessmentBaselineRule VA1234 /{resourceId}/providers/Microsoft.Security/sqlVulnerabilityAssessments/default/baselineRules/{ruleId}