Sql
data class SqlVulnerabilityAssessmentBaselineRuleArgs(val latestScan: Output<Boolean>? = null, val resourceId: Output<String>? = null, val results: Output<List<List<String>>>? = null, val ruleId: Output<String>? = null, val workspaceId: Output<String>? = null) : ConvertibleToJava<SqlVulnerabilityAssessmentBaselineRuleArgs>
Rule results. Uses Azure REST API version 2023-02-01-preview. In version 1.x of the Azure Native provider, it used API version 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",
});
});Content copied to clipboard
package main
import (
security "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
})
}Content copied to clipboard
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());
}
}Content copied to clipboard
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",
});
});Content copied to clipboard
package main
import (
security "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
})
}Content copied to clipboard
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());
}
}Content copied to clipboard
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}Content copied to clipboard