Microsoft.Sql servers/databases/securityAlertPolicies 2020-02-02-preview

Template format

To create a Microsoft.Sql/servers/databases/securityAlertPolicies resource, add the following JSON to the resources section of your template.

  "name": "string",
  "type": "Microsoft.Sql/servers/databases/securityAlertPolicies",
  "apiVersion": "2020-02-02-preview",
  "properties": {
    "state": "string"

Property values

The following tables describe the values you need to set in the schema.

Microsoft.Sql/servers/databases/securityAlertPolicies object

Name Type Required Value
name string Yes The name of the security alert policy.
type enum Yes securityAlertPolicies

See Set name and type for child resources.
apiVersion enum Yes 2020-02-02-preview
properties object Yes Resource properties. - SecurityAlertsPolicyProperties object

SecurityAlertsPolicyProperties object

Name Type Required Value
state enum Yes Specifies the state of the policy, whether it is enabled or disabled or a policy has not been applied yet on the specific database. - Enabled or Disabled

Quickstart templates

The following quickstart templates deploy this resource type.

Template Description
Azure SQL Server + multiple SQL DBs with Threat Detection

Deploy to Azure
This template allows you to deploy an Azure SQL Server and a user-defined number of Azure SQL Databases with Threat Detection enabled, with an email address to receive alerts for each database.