Policy: Azure > SQL > Server > Active Directory Administrator

Define the Active Directory Administrator settings required for Azure > SQL > Server.

The Active Directory Administrator policy determines what should be the active directory authentication value set for Azure SQL Server.

Enabling active directory authentication on a SQL server permits you to centrally manage identity and access Azure SQL Database.

Resource Types

This policy targets the following resource types:

Azure > SQL > Server

Name

Controls

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	`string`
Default	`Skip`
Valid Values [YAML]	`Skip` `Check: Disabled` `Check: Enabled` `Check: Enabled to Active Directory Administrator > Name` `Enforce: Disabled` `Enforce: Enabled to Active Directory Administrator > Name`
Examples [YAML]	`Skip`

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

GraphQL

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

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

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

CLI

Get Policy Type

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

Get Policy Settings

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