AWS database instances do not have deletion protection enabled misconfiguration detected in code

Rule Details

Cortex AppSec Rule ID	APPSEC_AWS_293
Category - Subcategory	Public Exposure - Database Endpoints
Provider	AWS
Severity	MEDIUM
Framework	Terraform, Terraform Plan

Impact

This rule is checking for whether AWS database instances have deletion protection enabled or not. If deletion protection is disallowed, there could be potential accidental loss of valuable or critical data. This can happen due to an inadvertent user action. Therefore, it's important for AWS database instances to have deletion protection enabled to prevent the unexpected removal of database that might cause data loss or downtime issues.

How to Fix

Terraform

• Resource: aws_db_instance
• Arguments: deletion_protection

To fix the issue:

You need to enable deletion_protection parameter in the AWS instance block. This ensures that the termination of this DB instance is prevented when this parameter is set to 'true'.

The above code is secure because the deletion_protection is set to true. This parameter ensures that the AWS database instance cannot be deleted. This adds an extra layer of security against accidental deletions of the AWS database instances. [source,go]

resource "aws_db_instance" "default" { ...

• deletion_protection = true }

---