This policy checks all Azure MySQL Servers to ensure that they enforce SSL connections. An incident is raised with the offending MySQL Servers if any are found that don't.
The Azure Resource Manager API is used to get a list of subscriptions and MySQL Servers within those subscriptions. The policy then checks "properties.sslEnforcement" for each server to verify that it is set to "Enabled".
This policy has the following input parameters required when launching the policy.
- Email addresses to notify - Email addresses of the recipients you wish to notify when new incidents are created
- Azure Endpoint - Azure Endpoint to access resources
This policy uses credentials for connecting to the cloud -- in order to apply this policy you must have a credential registered in the system that is compatible with this policy. If there are no credentials listed when you apply the policy, please contact your cloud admin and ask them to register a credential that is compatible with this policy. The information below should be consulted when creating the credential.
For administrators creating and managing credentials to use with this policy, the following information is needed:
Provider tag values to match this policy: azure_rm
Required permissions in the provider:
- Microsoft.Resources/subscriptions/read
- Microsoft.DBforMySQL/servers/read
- Azure Resource Manager
This Policy Template does not incur any cloud costs.