Query: An Azure Active Directory administrator should be provisioned for SQL servers

Description

Audit provisioning of an Azure Active Directory administrator for your SQL server to enable Azure AD authentication. Azure AD authentication enables simplified permission management and centralized identity management of database users and other Microsoft services.

Query

Tables used in this query:

• azure_sql_server
• azure_subscription

Controls using this query:

• An Azure Active Directory administrator should be provisioned for SQL servers

SQL