Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Native v1
  3. API Docs
  4. synapse
  5. SqlPoolVulnerabilityAssessmentRuleBaseline
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
pulumi/pulumi-azure-native

azure-native.synapse.SqlPoolVulnerabilityAssessmentRuleBaseline

Explore with Pulumi AI

azure-native-v1 logo
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
pulumi/pulumi-azure-native

    A Sql pool vulnerability assessment rule baseline. API Version: 2021-03-01.

    Example Usage

    Creates or updates a database's vulnerability assessment rule baseline.

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlPoolVulnerabilityAssessmentRuleBaseline = new AzureNative.Synapse.SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaseline", new()
    {
        BaselineName = "default",
        BaselineResults = new[]
        {
            new AzureNative.Synapse.Inputs.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs
            {
                Result = new[]
                {
                    "userA",
                    "SELECT",
                },
            },
            new AzureNative.Synapse.Inputs.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs
            {
                Result = new[]
                {
                    "userB",
                    "SELECT",
                },
            },
            new AzureNative.Synapse.Inputs.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs
            {
                Result = new[]
                {
                    "userC",
                    "SELECT",
                    "tableId_4",
                },
            },
        },
        ResourceGroupName = "vulnerabilityaseessmenttest-4799",
        RuleId = "VA1001",
        SqlPoolName = "testdb",
        VulnerabilityAssessmentName = "default",
        WorkspaceName = "vulnerabilityaseessmenttest-6440",
    });

});

    package main

import (
	synapse "github.com/pulumi/pulumi-azure-native-sdk/synapse"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := synapse.NewSqlPoolVulnerabilityAssessmentRuleBaseline(ctx, "sqlPoolVulnerabilityAssessmentRuleBaseline", &synapse.SqlPoolVulnerabilityAssessmentRuleBaselineArgs{
			BaselineName: pulumi.String("default"),
			BaselineResults: []synapse.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs{
				{
					Result: pulumi.StringArray{
						pulumi.String("userA"),
						pulumi.String("SELECT"),
					},
				},
				{
					Result: pulumi.StringArray{
						pulumi.String("userB"),
						pulumi.String("SELECT"),
					},
				},
				{
					Result: pulumi.StringArray{
						pulumi.String("userC"),
						pulumi.String("SELECT"),
						pulumi.String("tableId_4"),
					},
				},
			},
			ResourceGroupName:           pulumi.String("vulnerabilityaseessmenttest-4799"),
			RuleId:                      pulumi.String("VA1001"),
			SqlPoolName:                 pulumi.String("testdb"),
			VulnerabilityAssessmentName: pulumi.String("default"),
			WorkspaceName:               pulumi.String("vulnerabilityaseessmenttest-6440"),
		})
		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.synapse.SqlPoolVulnerabilityAssessmentRuleBaseline;
import com.pulumi.azurenative.synapse.SqlPoolVulnerabilityAssessmentRuleBaselineArgs;
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 sqlPoolVulnerabilityAssessmentRuleBaseline = new SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaseline", SqlPoolVulnerabilityAssessmentRuleBaselineArgs.builder()        
            .baselineName("default")
            .baselineResults(            
                Map.of("result",                 
                    "userA",
                    "SELECT"),
                Map.of("result",                 
                    "userB",
                    "SELECT"),
                Map.of("result",                 
                    "userC",
                    "SELECT",
                    "tableId_4"))
            .resourceGroupName("vulnerabilityaseessmenttest-4799")
            .ruleId("VA1001")
            .sqlPoolName("testdb")
            .vulnerabilityAssessmentName("default")
            .workspaceName("vulnerabilityaseessmenttest-6440")
            .build());

    }
}

    import pulumi
import pulumi_azure_native as azure_native

sql_pool_vulnerability_assessment_rule_baseline = azure_native.synapse.SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaseline",
    baseline_name="default",
    baseline_results=[
        azure_native.synapse.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs(
            result=[
                "userA",
                "SELECT",
            ],
        ),
        azure_native.synapse.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs(
            result=[
                "userB",
                "SELECT",
            ],
        ),
        azure_native.synapse.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs(
            result=[
                "userC",
                "SELECT",
                "tableId_4",
            ],
        ),
    ],
    resource_group_name="vulnerabilityaseessmenttest-4799",
    rule_id="VA1001",
    sql_pool_name="testdb",
    vulnerability_assessment_name="default",
    workspace_name="vulnerabilityaseessmenttest-6440")

    import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlPoolVulnerabilityAssessmentRuleBaseline = new azure_native.synapse.SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaseline", {
    baselineName: "default",
    baselineResults: [
        {
            result: [
                "userA",
                "SELECT",
            ],
        },
        {
            result: [
                "userB",
                "SELECT",
            ],
        },
        {
            result: [
                "userC",
                "SELECT",
                "tableId_4",
            ],
        },
    ],
    resourceGroupName: "vulnerabilityaseessmenttest-4799",
    ruleId: "VA1001",
    sqlPoolName: "testdb",
    vulnerabilityAssessmentName: "default",
    workspaceName: "vulnerabilityaseessmenttest-6440",
});

    resources:
  sqlPoolVulnerabilityAssessmentRuleBaseline:
    type: azure-native:synapse:SqlPoolVulnerabilityAssessmentRuleBaseline
    properties:
      baselineName: default
      baselineResults:
        - result:
            - userA
            - SELECT
        - result:
            - userB
            - SELECT
        - result:
            - userC
            - SELECT
            - tableId_4
      resourceGroupName: vulnerabilityaseessmenttest-4799
      ruleId: VA1001
      sqlPoolName: testdb
      vulnerabilityAssessmentName: default
      workspaceName: vulnerabilityaseessmenttest-6440

    Create SqlPoolVulnerabilityAssessmentRuleBaseline Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new SqlPoolVulnerabilityAssessmentRuleBaseline(name: string, args: SqlPoolVulnerabilityAssessmentRuleBaselineArgs, opts?: CustomResourceOptions);
    @overload
def SqlPoolVulnerabilityAssessmentRuleBaseline(resource_name: str,
                                               args: SqlPoolVulnerabilityAssessmentRuleBaselineArgs,
                                               opts: Optional[ResourceOptions] = None)

@overload
def SqlPoolVulnerabilityAssessmentRuleBaseline(resource_name: str,
                                               opts: Optional[ResourceOptions] = None,
                                               baseline_results: Optional[Sequence[SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs]] = None,
                                               resource_group_name: Optional[str] = None,
                                               rule_id: Optional[str] = None,
                                               sql_pool_name: Optional[str] = None,
                                               vulnerability_assessment_name: Optional[str] = None,
                                               workspace_name: Optional[str] = None,
                                               baseline_name: Optional[str] = None)
    func NewSqlPoolVulnerabilityAssessmentRuleBaseline(ctx *Context, name string, args SqlPoolVulnerabilityAssessmentRuleBaselineArgs, opts ...ResourceOption) (*SqlPoolVulnerabilityAssessmentRuleBaseline, error)
    public SqlPoolVulnerabilityAssessmentRuleBaseline(string name, SqlPoolVulnerabilityAssessmentRuleBaselineArgs args, CustomResourceOptions? opts = null)
    public SqlPoolVulnerabilityAssessmentRuleBaseline(String name, SqlPoolVulnerabilityAssessmentRuleBaselineArgs args)
public SqlPoolVulnerabilityAssessmentRuleBaseline(String name, SqlPoolVulnerabilityAssessmentRuleBaselineArgs args, CustomResourceOptions options)

    type: azure-native:synapse:SqlPoolVulnerabilityAssessmentRuleBaseline
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args SqlPoolVulnerabilityAssessmentRuleBaselineArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args SqlPoolVulnerabilityAssessmentRuleBaselineArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args SqlPoolVulnerabilityAssessmentRuleBaselineArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SqlPoolVulnerabilityAssessmentRuleBaselineArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SqlPoolVulnerabilityAssessmentRuleBaselineArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var sqlPoolVulnerabilityAssessmentRuleBaselineResource = new AzureNative.Synapse.SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaselineResource", new()
{
    BaselineResults = new[]
    {
        
        {
            { "result", new[]
            {
                "string",
            } },
        },
    },
    ResourceGroupName = "string",
    RuleId = "string",
    SqlPoolName = "string",
    VulnerabilityAssessmentName = "string",
    WorkspaceName = "string",
    BaselineName = "string",
});

    example, err := synapse.NewSqlPoolVulnerabilityAssessmentRuleBaseline(ctx, "sqlPoolVulnerabilityAssessmentRuleBaselineResource", &synapse.SqlPoolVulnerabilityAssessmentRuleBaselineArgs{
	BaselineResults: []map[string]interface{}{
		map[string]interface{}{
			"result": []string{
				"string",
			},
		},
	},
	ResourceGroupName:           "string",
	RuleId:                      "string",
	SqlPoolName:                 "string",
	VulnerabilityAssessmentName: "string",
	WorkspaceName:               "string",
	BaselineName:                "string",
})

    var sqlPoolVulnerabilityAssessmentRuleBaselineResource = new SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaselineResource", SqlPoolVulnerabilityAssessmentRuleBaselineArgs.builder()
    .baselineResults(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .resourceGroupName("string")
    .ruleId("string")
    .sqlPoolName("string")
    .vulnerabilityAssessmentName("string")
    .workspaceName("string")
    .baselineName("string")
    .build());

    sql_pool_vulnerability_assessment_rule_baseline_resource = azure_native.synapse.SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaselineResource",
    baseline_results=[{
        result: [string],
    }],
    resource_group_name=string,
    rule_id=string,
    sql_pool_name=string,
    vulnerability_assessment_name=string,
    workspace_name=string,
    baseline_name=string)

    const sqlPoolVulnerabilityAssessmentRuleBaselineResource = new azure_native.synapse.SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaselineResource", {
    baselineResults: [{
        result: ["string"],
    }],
    resourceGroupName: "string",
    ruleId: "string",
    sqlPoolName: "string",
    vulnerabilityAssessmentName: "string",
    workspaceName: "string",
    baselineName: "string",
});

    type: azure-native:synapse:SqlPoolVulnerabilityAssessmentRuleBaseline
properties:
    baselineName: string
    baselineResults:
        - result:
            - string
    resourceGroupName: string
    ruleId: string
    sqlPoolName: string
    vulnerabilityAssessmentName: string
    workspaceName: string

    SqlPoolVulnerabilityAssessmentRuleBaseline Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The SqlPoolVulnerabilityAssessmentRuleBaseline resource accepts the following input properties:

    BaselineResults List<Pulumi.AzureNative.Synapse.Inputs.SqlPoolVulnerabilityAssessmentRuleBaselineItem>
    The rule baseline result
    ResourceGroupName string
    The name of the resource group. The name is case insensitive.
    RuleId string
    The vulnerability assessment rule ID.
    SqlPoolName string
    SQL pool name
    VulnerabilityAssessmentName string
    The name of the vulnerability assessment.
    WorkspaceName string
    The name of the workspace
    BaselineName string
    The name of the vulnerability assessment rule baseline (default implies a baseline on a Sql pool level rule and master for workspace level rule).
    BaselineResults []SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs
    The rule baseline result
    ResourceGroupName string
    The name of the resource group. The name is case insensitive.
    RuleId string
    The vulnerability assessment rule ID.
    SqlPoolName string
    SQL pool name
    VulnerabilityAssessmentName string
    The name of the vulnerability assessment.
    WorkspaceName string
    The name of the workspace
    BaselineName string
    The name of the vulnerability assessment rule baseline (default implies a baseline on a Sql pool level rule and master for workspace level rule).
    baselineResults List<SqlPoolVulnerabilityAssessmentRuleBaselineItem>
    The rule baseline result
    resourceGroupName String
    The name of the resource group. The name is case insensitive.
    ruleId String
    The vulnerability assessment rule ID.
    sqlPoolName String
    SQL pool name
    vulnerabilityAssessmentName String
    The name of the vulnerability assessment.
    workspaceName String
    The name of the workspace
    baselineName String
    The name of the vulnerability assessment rule baseline (default implies a baseline on a Sql pool level rule and master for workspace level rule).
    baselineResults SqlPoolVulnerabilityAssessmentRuleBaselineItem[]
    The rule baseline result
    resourceGroupName string
    The name of the resource group. The name is case insensitive.
    ruleId string
    The vulnerability assessment rule ID.
    sqlPoolName string
    SQL pool name
    vulnerabilityAssessmentName string
    The name of the vulnerability assessment.
    workspaceName string
    The name of the workspace
    baselineName string
    The name of the vulnerability assessment rule baseline (default implies a baseline on a Sql pool level rule and master for workspace level rule).
    baseline_results Sequence[SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs]
    The rule baseline result
    resource_group_name str
    The name of the resource group. The name is case insensitive.
    rule_id str
    The vulnerability assessment rule ID.
    sql_pool_name str
    SQL pool name
    vulnerability_assessment_name str
    The name of the vulnerability assessment.
    workspace_name str
    The name of the workspace
    baseline_name str
    The name of the vulnerability assessment rule baseline (default implies a baseline on a Sql pool level rule and master for workspace level rule).
    baselineResults List<Property Map>
    The rule baseline result
    resourceGroupName String
    The name of the resource group. The name is case insensitive.
    ruleId String
    The vulnerability assessment rule ID.
    sqlPoolName String
    SQL pool name
    vulnerabilityAssessmentName String
    The name of the vulnerability assessment.
    workspaceName String
    The name of the workspace
    baselineName String
    The name of the vulnerability assessment rule baseline (default implies a baseline on a Sql pool level rule and master for workspace level rule).

    Outputs

    All input properties are implicitly available as output properties. Additionally, the SqlPoolVulnerabilityAssessmentRuleBaseline resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    The name of the resource
    Type string
    The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    The name of the resource
    Type string
    The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    The name of the resource
    type String
    The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
    id string
    The provider-assigned unique ID for this managed resource.
    name string
    The name of the resource
    type string
    The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
    id str
    The provider-assigned unique ID for this managed resource.
    name str
    The name of the resource
    type str
    The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    The name of the resource
    type String
    The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

    Supporting Types

    SqlPoolVulnerabilityAssessmentRuleBaselineItem, SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs

    Result List<string>
    The rule baseline result
    Result []string
    The rule baseline result
    result List<String>
    The rule baseline result
    result string[]
    The rule baseline result
    result Sequence[str]
    The rule baseline result
    result List<String>
    The rule baseline result

    SqlPoolVulnerabilityAssessmentRuleBaselineItemResponse, SqlPoolVulnerabilityAssessmentRuleBaselineItemResponseArgs

    Result List<string>
    The rule baseline result
    Result []string
    The rule baseline result
    result List<String>
    The rule baseline result
    result string[]
    The rule baseline result
    result Sequence[str]
    The rule baseline result
    result List<String>
    The rule baseline result

    Import

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

    $ pulumi import azure-native:synapse:SqlPoolVulnerabilityAssessmentRuleBaseline default /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/vulnerabilityaseessmenttest-4799/providers/Microsoft.Synapse/workspaces/vulnerabilityaseessmenttest-6440/sqlPools/testdb/vulnerabilityAssessments/default/rules/VA1001/baselines/default

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    azure-native-v1 pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native-v1 logo
    These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
    Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi
    pulumi/pulumi-azure-native