Sql Pool Vulnerability Assessment Rule Baseline
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",
});
});
Content copied to clipboard
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
})
}
Content copied to clipboard
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());
}
}
Content copied to clipboard
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
Content copied to clipboard