Query: Ensure server parameter 'require_secure_transport' is set to 'ON' for PostgreSQL flexible server

Description

Enable 'require_secure_transport' on 'PostgreSQL flexible servers'.

Query

Tables used in this query:

• azure_postgresql_flexible_server
• azure_subscription

Controls using this query:

• 5.2.1 Ensure server parameter 'require_secure_transport' is set to 'ON' for PostgreSQL flexible server
• Ensure server parameter 'require_secure_transport' is set to 'ON' for PostgreSQL flexible server

SQL