Query: Public network access should be disabled for PostgreSQL servers

Description

Disable the public network access property to improve security and ensure your Azure Database for PostgreSQL can only be accessed from a private endpoint. This configuration disables access from any public address space outside of Azure IP range, and denies all logins that match IP or virtual network-based firewall rules.

Query

Tables used in this query:

• azure_postgresql_server
• azure_subscription

Controls using this query:

• Public network access should be disabled for PostgreSQL servers

SQL