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

A read-only Object Control List (OCL) to approve or reject IP addresses for a server firewall. This list is compiled from specified approved IP addresses and additional filtering rules.

This policy is generated by Guardrails and is designed to ensure that only approved IP addresses are allowed access, aligning with security and compliance standards.

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`

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/serverFirewallIpRangesApprovedCompiledRules

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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