Control: Azure > SQL > Server > Active Directory Administrator

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

The Active Directory Administrator control 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 control targets the following resource types:

Azure > SQL > Server

Policies

The following policies can be used to configure this control:

Azure > SQL > Server > Active Directory Administrator

This control type relies on these other policies when running actions:

Azure > SQL > Server > Active Directory Administrator > Name

Permissions

Cloud permissions used by this control and its actions:

microsoft.sql/servers/administrators/write
microsoft.sql/servers/administrators/delete
microsoft.sql/servers/azureadonlyauthentications/write
microsoft.sql/servers/azureadonlyauthentications/delete
User.Read.All
Application.Read.All
Group.Read.All

In Your Workspace

Developers

Control Type URI

tmod:@turbot/azure-sql#/control/types/serverActiveDirectoryAdministrator

Category URI

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

GraphQL

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

query controls(filter: "controlTypeId:'tmod:@turbot/azure-sql#/control/types/serverActiveDirectoryAdministrator'") { … }

CLI

Get Controls

turbot graphql controls --filter "controlTypeId:tmod:@turbot/azure-sql#/control/types/serverActiveDirectoryAdministrator"