Use Pulumi's new import command to generate code from existing cloud resources. Learn More
  1. Docs
  2. Reference
  3. API
  4. Azure NextGen
  5. synapse
  6. SqlPoolVulnerabilityAssessmentRuleBaseline

SqlPoolVulnerabilityAssessmentRuleBaseline

A Sql pool vulnerability assessment rule baseline.

Example Usage

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

using Pulumi;
using AzureNextGen = Pulumi.AzureNextGen;

class MyStack : Stack
{
    public MyStack()
    {
        var sqlPoolVulnerabilityAssessmentRuleBaseline = new AzureNextGen.Synapse.V20190601Preview.SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaseline", new AzureNextGen.Synapse.V20190601Preview.SqlPoolVulnerabilityAssessmentRuleBaselineArgs
        {
            BaselineName = "default",
            BaselineResults = 
            {
                new AzureNextGen.Synapse.V20190601Preview.Inputs.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs
                {
                    Result = 
                    {
                        "userA",
                        "SELECT",
                    },
                },
                new AzureNextGen.Synapse.V20190601Preview.Inputs.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs
                {
                    Result = 
                    {
                        "userB",
                        "SELECT",
                    },
                },
                new AzureNextGen.Synapse.V20190601Preview.Inputs.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs
                {
                    Result = 
                    {
                        "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-nextgen/sdk/go/azure/synapse/v20190601preview"
    "github.com/pulumi/pulumi/sdk/v2/go/pulumi"
)

func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
        _, err := synapse.NewSqlPoolVulnerabilityAssessmentRuleBaseline(ctx, "sqlPoolVulnerabilityAssessmentRuleBaseline", &synapse.SqlPoolVulnerabilityAssessmentRuleBaselineArgs{
            BaselineName: pulumi.String("default"),
            BaselineResults: synapse.SqlPoolVulnerabilityAssessmentRuleBaselineItemArray{
                &synapse.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs{
                    Result: pulumi.StringArray{
                        pulumi.String("userA"),
                        pulumi.String("SELECT"),
                    },
                },
                &synapse.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs{
                    Result: pulumi.StringArray{
                        pulumi.String("userB"),
                        pulumi.String("SELECT"),
                    },
                },
                &synapse.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs{
                    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
    })
}
import pulumi
import pulumi_azure_nextgen as azure_nextgen

sql_pool_vulnerability_assessment_rule_baseline = azure_nextgen.synapse.v20190601preview.SqlPoolVulnerabilityAssessmentRuleBaseline("sqlPoolVulnerabilityAssessmentRuleBaseline",
    baseline_name="default",
    baseline_results=[
        azure_nextgen.synapse.v20190601preview.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs(
            result=[
                "userA",
                "SELECT",
            ],
        ),
        azure_nextgen.synapse.v20190601preview.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs(
            result=[
                "userB",
                "SELECT",
            ],
        ),
        azure_nextgen.synapse.v20190601preview.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_nextgen from "@pulumi/azure-nextgen";

const sqlPoolVulnerabilityAssessmentRuleBaseline = new azure_nextgen.synapse.v20190601preview.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",
});

Create a SqlPoolVulnerabilityAssessmentRuleBaseline Resource

new SqlPoolVulnerabilityAssessmentRuleBaseline(name: string, args: SqlPoolVulnerabilityAssessmentRuleBaselineArgs, opts?: CustomResourceOptions);
def SqlPoolVulnerabilityAssessmentRuleBaseline(resource_name: str, opts: Optional[ResourceOptions] = None, baseline_name: Optional[str] = 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)
func NewSqlPoolVulnerabilityAssessmentRuleBaseline(ctx *Context, name string, args SqlPoolVulnerabilityAssessmentRuleBaselineArgs, opts ...ResourceOption) (*SqlPoolVulnerabilityAssessmentRuleBaseline, error)
public SqlPoolVulnerabilityAssessmentRuleBaseline(string name, SqlPoolVulnerabilityAssessmentRuleBaselineArgs args, CustomResourceOptions? opts = null)
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.
opts ResourceOptions
A bag of options that control this 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.

SqlPoolVulnerabilityAssessmentRuleBaseline Resource Properties

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

Inputs

The SqlPoolVulnerabilityAssessmentRuleBaseline resource accepts the following input properties:

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<Pulumi.AzureNextGen.Synapse.Inputs.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 []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
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).
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

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 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”

Supporting Types

SqlPoolVulnerabilityAssessmentRuleBaselineItem

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

SqlPoolVulnerabilityAssessmentRuleBaselineItemResponse

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

Import

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

$ pulumi import azure-nextgen:synapse/v20190601preview: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

Package Details

Repository
https://github.com/pulumi/pulumi-azure-nextgen
License
Apache-2.0