Policy: Azure > SQL > Server > Firewall > IP Ranges > Approved > Rules

An Object Control List (OCL) with a list of filter rules to approve or reject IP ranges for a SQL server firewall.

Note that the Approved control does not operate directly from this policy, but from the Approved > Compiled Rules. The rules are processed in order, and any built-in Guardrails rules will appear first in the list of compiled rules.

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 > Firewall > IP Ranges > Approved

Controls

Policy Specification

Schema Type	`string`
Default	`APPROVE *`

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

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

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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