Azure-PostgreSQLServer-Azure-Active-Directory-Admin-Configured

Severity: Medium

Description: This control ensures that Azure Active Directory Admin is set for a PostgreSQL server to allow connection only through Azure AD Users instead of native PostgreSQL server authentication. With Azure AD authentication, can manage the identities of database users and other Microsoft services in one central location. Central ID management provides a single place to manage database users and simplifies permission management.

Remediation Steps:

Perform following to update PostgreSQL parameters:

1. LoLogin to Azure Portal using https://portal.azure.com.

2. Go to PostgreSQL server.

3. Click PostgreSQL databases instance to configure Active Directory admin

4. Click on Active Directory admin.

5. Click Set Admin.

6. Select an admin.

7. Click Save.

Important:

Reference:

• https://docs.microsoft.com/en-us/azure/postgresql/concepts-aad-authentication