Control: 8 RDS DB instances should have deletion protection enabled
Description
This control checks whether your RDS DB instances that use one of the listed database engines have deletion protection enabled.
Enabling instance deletion protection is an additional layer of protection against accidental database deletion or deletion by an unauthorized entity.
While deletion protection is enabled, an RDS DB instance cannot be deleted. Before a deletion request can succeed, deletion protection must be disabled.
Remediation
To remediate this issue, update your RDS DB instance to enable deletion protection.
To enable deletion protection for an RDS DB instance
- Open the Amazon RDS console.
- In the navigation pane, choose
Databases
, then choose the DB instance that you want to modify. - Choose
Modify
. - Under
Deletion protection
, chooseEnable deletion protection
. - Choose
Continue
. - Under
Scheduling of modifications
, choose when to apply modifications. The options areApply during the next scheduled maintenance window
orApply immediately
. - Choose
Modify DB Instance
.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.foundational_security_rds_8
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.foundational_security_rds_8 --share
SQL
This control uses a named query:
rds_db_instance_deletion_protection_enabled