Azure Native v1.102.0, May 2 23

azure-native.sql.ServerSecurityAlertPolicy

Explore with Pulumi AI

A server security alert policy. API Version: 2020-11-01-preview.

Example Usage

Update a server's threat detection policy with all parameters

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

return await Deployment.RunAsync(() => 
{
    var serverSecurityAlertPolicy = new AzureNative.Sql.ServerSecurityAlertPolicy("serverSecurityAlertPolicy", new()
    {
        DisabledAlerts = new[]
        {
            "Access_Anomaly",
            "Usage_Anomaly",
        },
        EmailAccountAdmins = true,
        EmailAddresses = new[]
        {
            "testSecurityAlert@microsoft.com",
        },
        ResourceGroupName = "securityalert-4799",
        RetentionDays = 5,
        SecurityAlertPolicyName = "Default",
        ServerName = "securityalert-6440",
        State = AzureNative.Sql.SecurityAlertsPolicyState.Enabled,
        StorageAccountAccessKey = "sdlfkjabc+sdlfkjsdlkfsjdfLDKFTERLKFDFKLjsdfksjdflsdkfD2342309432849328476458/3RSD==",
        StorageEndpoint = "https://mystorage.blob.core.windows.net",
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewServerSecurityAlertPolicy(ctx, "serverSecurityAlertPolicy", &sql.ServerSecurityAlertPolicyArgs{
			DisabledAlerts: pulumi.StringArray{
				pulumi.String("Access_Anomaly"),
				pulumi.String("Usage_Anomaly"),
			},
			EmailAccountAdmins: pulumi.Bool(true),
			EmailAddresses: pulumi.StringArray{
				pulumi.String("testSecurityAlert@microsoft.com"),
			},
			ResourceGroupName:       pulumi.String("securityalert-4799"),
			RetentionDays:           pulumi.Int(5),
			SecurityAlertPolicyName: pulumi.String("Default"),
			ServerName:              pulumi.String("securityalert-6440"),
			State:                   sql.SecurityAlertsPolicyStateEnabled,
			StorageAccountAccessKey: pulumi.String("sdlfkjabc+sdlfkjsdlkfsjdfLDKFTERLKFDFKLjsdfksjdflsdkfD2342309432849328476458/3RSD=="),
			StorageEndpoint:         pulumi.String("https://mystorage.blob.core.windows.net"),
		})
		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.sql.ServerSecurityAlertPolicy;
import com.pulumi.azurenative.sql.ServerSecurityAlertPolicyArgs;
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 serverSecurityAlertPolicy = new ServerSecurityAlertPolicy("serverSecurityAlertPolicy", ServerSecurityAlertPolicyArgs.builder()        
            .disabledAlerts(            
                "Access_Anomaly",
                "Usage_Anomaly")
            .emailAccountAdmins(true)
            .emailAddresses("testSecurityAlert@microsoft.com")
            .resourceGroupName("securityalert-4799")
            .retentionDays(5)
            .securityAlertPolicyName("Default")
            .serverName("securityalert-6440")
            .state("Enabled")
            .storageAccountAccessKey("sdlfkjabc+sdlfkjsdlkfsjdfLDKFTERLKFDFKLjsdfksjdflsdkfD2342309432849328476458/3RSD==")
            .storageEndpoint("https://mystorage.blob.core.windows.net")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

server_security_alert_policy = azure_native.sql.ServerSecurityAlertPolicy("serverSecurityAlertPolicy",
    disabled_alerts=[
        "Access_Anomaly",
        "Usage_Anomaly",
    ],
    email_account_admins=True,
    email_addresses=["testSecurityAlert@microsoft.com"],
    resource_group_name="securityalert-4799",
    retention_days=5,
    security_alert_policy_name="Default",
    server_name="securityalert-6440",
    state=azure_native.sql.SecurityAlertsPolicyState.ENABLED,
    storage_account_access_key="sdlfkjabc+sdlfkjsdlkfsjdfLDKFTERLKFDFKLjsdfksjdflsdkfD2342309432849328476458/3RSD==",
    storage_endpoint="https://mystorage.blob.core.windows.net")

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

const serverSecurityAlertPolicy = new azure_native.sql.ServerSecurityAlertPolicy("serverSecurityAlertPolicy", {
    disabledAlerts: [
        "Access_Anomaly",
        "Usage_Anomaly",
    ],
    emailAccountAdmins: true,
    emailAddresses: ["testSecurityAlert@microsoft.com"],
    resourceGroupName: "securityalert-4799",
    retentionDays: 5,
    securityAlertPolicyName: "Default",
    serverName: "securityalert-6440",
    state: azure_native.sql.SecurityAlertsPolicyState.Enabled,
    storageAccountAccessKey: "sdlfkjabc+sdlfkjsdlkfsjdfLDKFTERLKFDFKLjsdfksjdflsdkfD2342309432849328476458/3RSD==",
    storageEndpoint: "https://mystorage.blob.core.windows.net",
});

resources:
  serverSecurityAlertPolicy:
    type: azure-native:sql:ServerSecurityAlertPolicy
    properties:
      disabledAlerts:
        - Access_Anomaly
        - Usage_Anomaly
      emailAccountAdmins: true
      emailAddresses:
        - testSecurityAlert@microsoft.com
      resourceGroupName: securityalert-4799
      retentionDays: 5
      securityAlertPolicyName: Default
      serverName: securityalert-6440
      state: Enabled
      storageAccountAccessKey: sdlfkjabc+sdlfkjsdlkfsjdfLDKFTERLKFDFKLjsdfksjdflsdkfD2342309432849328476458/3RSD==
      storageEndpoint: https://mystorage.blob.core.windows.net

Update a server's threat detection policy with minimal parameters

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

return await Deployment.RunAsync(() => 
{
    var serverSecurityAlertPolicy = new AzureNative.Sql.ServerSecurityAlertPolicy("serverSecurityAlertPolicy", new()
    {
        ResourceGroupName = "securityalert-4799",
        SecurityAlertPolicyName = "Default",
        ServerName = "securityalert-6440",
        State = AzureNative.Sql.SecurityAlertsPolicyState.Enabled,
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewServerSecurityAlertPolicy(ctx, "serverSecurityAlertPolicy", &sql.ServerSecurityAlertPolicyArgs{
			ResourceGroupName:       pulumi.String("securityalert-4799"),
			SecurityAlertPolicyName: pulumi.String("Default"),
			ServerName:              pulumi.String("securityalert-6440"),
			State:                   sql.SecurityAlertsPolicyStateEnabled,
		})
		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.sql.ServerSecurityAlertPolicy;
import com.pulumi.azurenative.sql.ServerSecurityAlertPolicyArgs;
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 serverSecurityAlertPolicy = new ServerSecurityAlertPolicy("serverSecurityAlertPolicy", ServerSecurityAlertPolicyArgs.builder()        
            .resourceGroupName("securityalert-4799")
            .securityAlertPolicyName("Default")
            .serverName("securityalert-6440")
            .state("Enabled")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

server_security_alert_policy = azure_native.sql.ServerSecurityAlertPolicy("serverSecurityAlertPolicy",
    resource_group_name="securityalert-4799",
    security_alert_policy_name="Default",
    server_name="securityalert-6440",
    state=azure_native.sql.SecurityAlertsPolicyState.ENABLED)

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

const serverSecurityAlertPolicy = new azure_native.sql.ServerSecurityAlertPolicy("serverSecurityAlertPolicy", {
    resourceGroupName: "securityalert-4799",
    securityAlertPolicyName: "Default",
    serverName: "securityalert-6440",
    state: azure_native.sql.SecurityAlertsPolicyState.Enabled,
});

resources:
  serverSecurityAlertPolicy:
    type: azure-native:sql:ServerSecurityAlertPolicy
    properties:
      resourceGroupName: securityalert-4799
      securityAlertPolicyName: Default
      serverName: securityalert-6440
      state: Enabled

Create ServerSecurityAlertPolicy Resource

new ServerSecurityAlertPolicy(name: string, args: ServerSecurityAlertPolicyArgs, opts?: CustomResourceOptions);

@overload
def ServerSecurityAlertPolicy(resource_name: str,
                              opts: Optional[ResourceOptions] = None,
                              disabled_alerts: Optional[Sequence[str]] = None,
                              email_account_admins: Optional[bool] = None,
                              email_addresses: Optional[Sequence[str]] = None,
                              resource_group_name: Optional[str] = None,
                              retention_days: Optional[int] = None,
                              security_alert_policy_name: Optional[str] = None,
                              server_name: Optional[str] = None,
                              state: Optional[SecurityAlertsPolicyState] = None,
                              storage_account_access_key: Optional[str] = None,
                              storage_endpoint: Optional[str] = None)
@overload
def ServerSecurityAlertPolicy(resource_name: str,
                              args: ServerSecurityAlertPolicyArgs,
                              opts: Optional[ResourceOptions] = None)

func NewServerSecurityAlertPolicy(ctx *Context, name string, args ServerSecurityAlertPolicyArgs, opts ...ResourceOption) (*ServerSecurityAlertPolicy, error)

public ServerSecurityAlertPolicy(string name, ServerSecurityAlertPolicyArgs args, CustomResourceOptions? opts = null)

public ServerSecurityAlertPolicy(String name, ServerSecurityAlertPolicyArgs args)
public ServerSecurityAlertPolicy(String name, ServerSecurityAlertPolicyArgs args, CustomResourceOptions options)

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

name string: The unique name of the resource.
args ServerSecurityAlertPolicyArgs: 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 ServerSecurityAlertPolicyArgs: 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 ServerSecurityAlertPolicyArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args ServerSecurityAlertPolicyArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args ServerSecurityAlertPolicyArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

ServerSecurityAlertPolicy Resource Properties

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

Inputs

The ServerSecurityAlertPolicy resource accepts the following input properties:

ResourceGroupName string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
ServerName string: The name of the server.
State Pulumi.AzureNative.Sql.SecurityAlertsPolicyState: Specifies the state of the policy, whether it is enabled or disabled or a policy has not been applied yet on the specific database.
DisabledAlerts List<string>: Specifies an array of alerts that are disabled. Allowed values are: Sql_Injection, Sql_Injection_Vulnerability, Access_Anomaly, Data_Exfiltration, Unsafe_Action, Brute_Force
EmailAccountAdmins bool: Specifies that the alert is sent to the account administrators.
EmailAddresses List<string>: Specifies an array of e-mail addresses to which the alert is sent.
RetentionDays int: Specifies the number of days to keep in the Threat Detection audit logs.
SecurityAlertPolicyName string: The name of the threat detection policy.
StorageAccountAccessKey string: Specifies the identifier key of the Threat Detection audit storage account.
StorageEndpoint string: Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

ResourceGroupName string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
ServerName string: The name of the server.
State SecurityAlertsPolicyState: Specifies the state of the policy, whether it is enabled or disabled or a policy has not been applied yet on the specific database.
DisabledAlerts []string: Specifies an array of alerts that are disabled. Allowed values are: Sql_Injection, Sql_Injection_Vulnerability, Access_Anomaly, Data_Exfiltration, Unsafe_Action, Brute_Force
EmailAccountAdmins bool: Specifies that the alert is sent to the account administrators.
EmailAddresses []string: Specifies an array of e-mail addresses to which the alert is sent.
RetentionDays int: Specifies the number of days to keep in the Threat Detection audit logs.
SecurityAlertPolicyName string: The name of the threat detection policy.
StorageAccountAccessKey string: Specifies the identifier key of the Threat Detection audit storage account.
StorageEndpoint string: Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

resourceGroupName String: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName String: The name of the server.
state SecurityAlertsPolicyState: Specifies the state of the policy, whether it is enabled or disabled or a policy has not been applied yet on the specific database.
disabledAlerts List<String>: Specifies an array of alerts that are disabled. Allowed values are: Sql_Injection, Sql_Injection_Vulnerability, Access_Anomaly, Data_Exfiltration, Unsafe_Action, Brute_Force
emailAccountAdmins Boolean: Specifies that the alert is sent to the account administrators.
emailAddresses List<String>: Specifies an array of e-mail addresses to which the alert is sent.
retentionDays Integer: Specifies the number of days to keep in the Threat Detection audit logs.
securityAlertPolicyName String: The name of the threat detection policy.
storageAccountAccessKey String: Specifies the identifier key of the Threat Detection audit storage account.
storageEndpoint String: Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

resourceGroupName string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName string: The name of the server.
state SecurityAlertsPolicyState: Specifies the state of the policy, whether it is enabled or disabled or a policy has not been applied yet on the specific database.
disabledAlerts string[]: Specifies an array of alerts that are disabled. Allowed values are: Sql_Injection, Sql_Injection_Vulnerability, Access_Anomaly, Data_Exfiltration, Unsafe_Action, Brute_Force
emailAccountAdmins boolean: Specifies that the alert is sent to the account administrators.
emailAddresses string[]: Specifies an array of e-mail addresses to which the alert is sent.
retentionDays number: Specifies the number of days to keep in the Threat Detection audit logs.
securityAlertPolicyName string: The name of the threat detection policy.
storageAccountAccessKey string: Specifies the identifier key of the Threat Detection audit storage account.
storageEndpoint string: Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

resource_group_name str: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
server_name str: The name of the server.
state SecurityAlertsPolicyState: Specifies the state of the policy, whether it is enabled or disabled or a policy has not been applied yet on the specific database.
disabled_alerts Sequence[str]: Specifies an array of alerts that are disabled. Allowed values are: Sql_Injection, Sql_Injection_Vulnerability, Access_Anomaly, Data_Exfiltration, Unsafe_Action, Brute_Force
email_account_admins bool: Specifies that the alert is sent to the account administrators.
email_addresses Sequence[str]: Specifies an array of e-mail addresses to which the alert is sent.
retention_days int: Specifies the number of days to keep in the Threat Detection audit logs.
security_alert_policy_name str: The name of the threat detection policy.
storage_account_access_key str: Specifies the identifier key of the Threat Detection audit storage account.
storage_endpoint str: Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

resourceGroupName String: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName String: The name of the server.
state "Enabled" | "Disabled": Specifies the state of the policy, whether it is enabled or disabled or a policy has not been applied yet on the specific database.
disabledAlerts List<String>: Specifies an array of alerts that are disabled. Allowed values are: Sql_Injection, Sql_Injection_Vulnerability, Access_Anomaly, Data_Exfiltration, Unsafe_Action, Brute_Force
emailAccountAdmins Boolean: Specifies that the alert is sent to the account administrators.
emailAddresses List<String>: Specifies an array of e-mail addresses to which the alert is sent.
retentionDays Number: Specifies the number of days to keep in the Threat Detection audit logs.
securityAlertPolicyName String: The name of the threat detection policy.
storageAccountAccessKey String: Specifies the identifier key of the Threat Detection audit storage account.
storageEndpoint String: Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.

Outputs

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

CreationTime string: Specifies the UTC creation time of the policy.
Id string: The provider-assigned unique ID for this managed resource.
Name string: Resource name.
SystemData Pulumi.AzureNative.Sql.Outputs.SystemDataResponse: SystemData of SecurityAlertPolicyResource.
Type string: Resource type.

CreationTime string: Specifies the UTC creation time of the policy.
Id string: The provider-assigned unique ID for this managed resource.
Name string: Resource name.
SystemData SystemDataResponse: SystemData of SecurityAlertPolicyResource.
Type string: Resource type.

creationTime String: Specifies the UTC creation time of the policy.
id String: The provider-assigned unique ID for this managed resource.
name String: Resource name.
systemData SystemDataResponse: SystemData of SecurityAlertPolicyResource.
type String: Resource type.

creationTime string: Specifies the UTC creation time of the policy.
id string: The provider-assigned unique ID for this managed resource.
name string: Resource name.
systemData SystemDataResponse: SystemData of SecurityAlertPolicyResource.
type string: Resource type.

creation_time str: Specifies the UTC creation time of the policy.
id str: The provider-assigned unique ID for this managed resource.
name str: Resource name.
system_data SystemDataResponse: SystemData of SecurityAlertPolicyResource.
type str: Resource type.

creationTime String: Specifies the UTC creation time of the policy.
id String: The provider-assigned unique ID for this managed resource.
name String: Resource name.
systemData Property Map: SystemData of SecurityAlertPolicyResource.
type String: Resource type.

Supporting Types

SecurityAlertsPolicyState

Enabled: Enabled
Disabled: Disabled

SecurityAlertsPolicyStateEnabled: Enabled
SecurityAlertsPolicyStateDisabled: Disabled

Enabled: Enabled
Disabled: Disabled

Enabled: Enabled
Disabled: Disabled

ENABLED: Enabled
DISABLED: Disabled

"Enabled": Enabled
"Disabled": Disabled

SystemDataResponse

CreatedAt string: The timestamp of resource creation (UTC).
CreatedBy string: The identity that created the resource.
CreatedByType string: The type of identity that created the resource.
LastModifiedAt string: The timestamp of resource last modification (UTC)
LastModifiedBy string: The identity that last modified the resource.
LastModifiedByType string: The type of identity that last modified the resource.

CreatedAt string: The timestamp of resource creation (UTC).
CreatedBy string: The identity that created the resource.
CreatedByType string: The type of identity that created the resource.
LastModifiedAt string: The timestamp of resource last modification (UTC)
LastModifiedBy string: The identity that last modified the resource.
LastModifiedByType string: The type of identity that last modified the resource.

createdAt String: The timestamp of resource creation (UTC).
createdBy String: The identity that created the resource.
createdByType String: The type of identity that created the resource.
lastModifiedAt String: The timestamp of resource last modification (UTC)
lastModifiedBy String: The identity that last modified the resource.
lastModifiedByType String: The type of identity that last modified the resource.

createdAt string: The timestamp of resource creation (UTC).
createdBy string: The identity that created the resource.
createdByType string: The type of identity that created the resource.
lastModifiedAt string: The timestamp of resource last modification (UTC)
lastModifiedBy string: The identity that last modified the resource.
lastModifiedByType string: The type of identity that last modified the resource.

created_at str: The timestamp of resource creation (UTC).
created_by str: The identity that created the resource.
created_by_type str: The type of identity that created the resource.
last_modified_at str: The timestamp of resource last modification (UTC)
last_modified_by str: The identity that last modified the resource.
last_modified_by_type str: The type of identity that last modified the resource.

createdAt String: The timestamp of resource creation (UTC).
createdBy String: The identity that created the resource.
createdByType String: The type of identity that created the resource.
lastModifiedAt String: The timestamp of resource last modification (UTC)
lastModifiedBy String: The identity that last modified the resource.
lastModifiedByType String: The type of identity that last modified the resource.

Import

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

$ pulumi import azure-native:sql:ServerSecurityAlertPolicy Default /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/securityalert-4799/providers/Microsoft.Sql/servers/securityalert-6440/securityAlertPolicies/default

Package Details

Repository: Azure Native pulumi/pulumi-azure-native
License: Apache-2.0