AWSOverview
Overview
In AWS, security groups can filter the traffic based on the security group of the source. Ideally, the security groups you use for your RDS instances only allow traffic originating from the application layer, which in most cases can be identified by certain security groups.
Remediation guidance
AWS remediation
Allow RDS access only from application security groups.
Console
- Open RDS instance security groups.
- Remove broad CIDR ingress for DB ports.
- Add inbound rules from application security group IDs only.
AWS CLI
aws ec2 authorize-security-group-ingress --group-id <db-sg-id> --protocol tcp --port <db-port> --source-group <app-sg-id>
aws ec2 revoke-security-group-ingress --group-id <db-sg-id> --protocol tcp --port <db-port> --cidr 0.0.0.0/0
References
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.RDSSecurityGroups.html
- https://docs.aws.amazon.com/cli/latest/reference/ec2/
Service-wide remediation
Recommended when many resources are affected: fix the platform baseline first so new resources inherit the secure setting, then remediate the existing flagged resources in batches.
AWS
Use AWS Organizations guardrails, AWS Config rules or conformance packs where they fit, approved account baselines, and IaC modules so new resources inherit the secure setting.
Operational rollout
- Fix the baseline first at the account, subscription, project, cluster, or tenant scope that owns this control.
- Remediate the currently affected resources in batches, starting with internet-exposed and production assets.
- Re-scan and track approved exceptions with an owner and expiry date.
Query logic
These are the stored checks tied to this control.
RDS Instances accept traffic only from the Application Servers
Connectors
Covered asset types
Expected check: eq []
{ dbInstances(where: {securityGroups_SOME: {rules_SOME: {direction: "Inbound", OR: [{destToPort_NOT_IN: [3306, 5432, 1521, 1433, 27017]}, {OR: [{sources_INCLUDES: "cidr:0.0.0.0/0"}, {sources_INCLUDES: "cidr:::/0"}]}]}}}) {...AssetFragment}}
