Control: 21 An RDS event notifications subscription should be configured for critical database parameter group events
Description
This control checks whether an Amazon RDS event subscription exists with notifications enabled for the following source type, event category key-value pairs.
DBParameterGroup: ["configuration change"]
RDS event notifications use Amazon SNS to make you aware of changes in the availability or configuration of your RDS resources. These notifications allow for rapid response. For additional information about RDS event notifications, see Using Using Amazon RDS event notification in the Amazon RDS User Guide.
Remediation
To subscribe to RDS database parameter group event notifications
Open the Amazon RDS console
In the navigation pane, choose
Event subscriptions
.Under
Event subscriptions
, chooseCreate event subscription
.In the
Create event subscription
dialog, do the following:a. For
Name
, enter a name for the event notification subscription.b. For
Send notifications to
, choose an existing Amazon SNS ARN for an SNS topic. To use a new topic, choosecreate topic
to enter the name of a topic and a list of recipients.c. For
Source type
, chooseParameter groups
.d. Under
Instances to include
, selectAll parameter groups
.e. Under
Event categories to include
, selectSpecific event categories
. The control also passes if you selectAll event categories
.f. Select
configuration change
.g. Choose
Create
.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.foundational_security_rds_21
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.foundational_security_rds_21 --share
SQL
This control uses a named query:
rds_db_parameter_group_events_subscription