Sql
data class SqlPoolVulnerabilityAssessmentRuleBaselineArgs(val baselineName: Output<String>? = null, val baselineResults: Output<List<SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs>>? = null, val resourceGroupName: Output<String>? = null, val ruleId: Output<String>? = null, val sqlPoolName: Output<String>? = null, val vulnerabilityAssessmentName: Output<String>? = null, val workspaceName: Output<String>? = null) : ConvertibleToJava<SqlPoolVulnerabilityAssessmentRuleBaselineArgs>
A Sql pool vulnerability assessment rule baseline. Uses Azure REST API version 2021-06-01. In version 2.x of the Azure Native provider, it used API version 2021-06-01. Other available API versions: 2021-04-01-preview, 2021-05-01, 2021-06-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native synapse [ApiVersion]. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.
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/v2"
"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.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
})
}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 com.pulumi.azurenative.synapse.inputs.SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs;
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(
SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs.builder()
.result(
"userA",
"SELECT")
.build(),
SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs.builder()
.result(
"userB",
"SELECT")
.build(),
SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs.builder()
.result(
"userC",
"SELECT",
"tableId_4")
.build())
.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/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/vulnerabilityAssessments/{vulnerabilityAssessmentName}/rules/{ruleId}/baselines/{baselineName}Content copied to clipboard
Constructors
Link copied to clipboard
constructor(baselineName: Output<String>? = null, baselineResults: Output<List<SqlPoolVulnerabilityAssessmentRuleBaselineItemArgs>>? = null, resourceGroupName: Output<String>? = null, ruleId: Output<String>? = null, sqlPoolName: Output<String>? = null, vulnerabilityAssessmentName: Output<String>? = null, workspaceName: Output<String>? = null)
Properties
Link copied to clipboard
The name of the vulnerability assessment rule baseline (default implies a baseline on a Sql pool level rule and master for workspace level rule).
Link copied to clipboard
The rule baseline result
Link copied to clipboard
The name of the resource group. The name is case insensitive.
Link copied to clipboard
SQL pool name
Link copied to clipboard
The name of the vulnerability assessment.
Link copied to clipboard
The name of the workspace.