azure_compliance

Azure Compliance

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.

sql_server_azure_ad_authentication_enabled

nist_sp_800_171_rev_2_3_1_1

3.1.1 Limit system access to authorized users, processes acting on behalf of authorized users, and devices (including other systems)

nist_sp_800_171_rev_2_3_1_2

3.1.2 Limit system access to the types of transactions and functions that authorized users are permitted to execute

nist_sp_800_171_rev_2_3_5_1

3.5.1 Identify system users, processes acting on behalf of users, and devices

nist_sp_800_171_rev_2_3_5_2

3.5.2 Authenticate (or verify) the identities of users, processes, or devices, as a prerequisite to allowing access to organizational systems.

nist_sp_800_171_rev_2_3_5_5

3.5.5 Prevent reuse of identifiers for a defined period

nist_sp_800_171_rev_2_3_5_6

3.5.6 Disable identifiers after a defined period of inactivity

fedramp_high_ac_2_1

AC-2(1) Automated System Account Management

fedramp_high_ac_2_7

AC-2(7) Role-Based Schemes

nist_sp_800_53_rev_5_ac_3

Access Enforcement (AC-3)

fedramp_high_ac_3

fedramp_high_ac_2

Account Management (AC-2)

nist_sp_800_53_rev_5_ac_2

nist_sp_800_53_rev_5_ac_2_1

Automated System Account Management AC-2(1)

fedramp_high_ia_2

Identification and Authentication (Organizational users) (IA-2)

nist_sp_800_53_rev_5_ia_2

Identification and Authentication (organizational Users) (IA-2)

nist_sp_800_53_rev_5_ia_4

Identifier Management (IA-4)

fedramp_high_ia_4

pci_dss_v321_requirement_3_2

PCI DSS requirement 3.2

pci_dss_v321_requirement_7_2_1

PCI DSS requirement 7.2.1

pci_dss_v321_requirement_8_3_1

PCI DSS requirement 8.3.1

nist_sp_800_53_rev_5_ac_2_7

Privileged User Accounts AC-2(7)

all_controls_sql

An Azure Active Directory administrator should be provisioned for SQL servers

azure

azuread

Run individual configuration, compliance and security controls or full compliance benchmarks for CIS, HIPAA HITRUST, NIST, PCI DSS across all your Azure subscriptions using Powerpipe and Steampipe.

Apache License 2.0

steampipe-mod-azure-compliance

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

Description

Usage

SQL

Tags