Policy: Azure > SQL > Server > Advanced Data Security > Threat Protection > Types

Define the threat protection types for Azure SQL server.

Advanced threat protection for the Azure SQL server detects anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases and it can trigger the following alerts.

Resource Types

This policy targets the following resource types:

Azure > SQL > Server

Primary Policy

This policy is used with the following primary policy:

Azure > SQL > Server > Advanced Data Security > Threat Protection

Controls

Azure > SQL > Server > Advanced Data Security

Policy Packs

This policy setting is used by the following policy packs:

Azure CIS v2.0.0 - Section 4 - Database Services

Policy Specification

Schema Type	`array`
Default	`- SQL Injection - SQL Injection Vulnerability - Data Exfiltration - Unsafe Action - Access Anomaly - Brute Force`

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/other

Policy Type URI

tmod:@turbot/azure-sql#/policy/types/serverThreatProtectionTypes

GraphQL

query policyType(id: "tmod:@turbot/azure-sql#/policy/types/serverThreatProtectionTypes") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/serverThreatProtectionTypes'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/serverThreatProtectionTypes'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-sql#/policy/types/serverThreatProtectionTypes"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sql#/policy/types/serverThreatProtectionTypes"