SaaS Multi-Tenant DB: Least-Privilege Security Group Chaining
Client Profile: Multi-tenant SaaS provider stores sensitive tenant records in Amazon RDS PostgreSQL. Problem: Security audit identified that the Database Security Group permits port 5432 ingress from the entire VPC CIDR (10.0.0.0/16), exposing the database to lateral traversal from non-production or test workloads.
Lab Objective
Replace CIDR 10.0.0.0/16 with the Application Security Group ID (sg-app) as the authorized source on port 5432.
Exam Track & Type
Solutions Architect Associate (SAA) (SAA-C03) · Live Outage Troubleshooting Drill
FinOps & Cost Impact
Security Group rule chaining provides zero-trust microsegmentation at $0 additional cost without requiring expensive virtual firewall appliances.
AWS Services Involved
Verification Success Criteria
- Database Security Group has source set to Application Security Group ID.
- Broad CIDR 10.0.0.0/16 removed from database ingress.
Diagnostic Starting Point (Spoiler-Free Hint)
Real Solutions Architect Interview Question
Frequently Asked Questions
How do I troubleshoot "SaaS Multi-Tenant DB: Least-Privilege Security Group Chaining" in AWS?
Why is granting port 5432 ingress to an entire 10.0.0.0/16 VPC CIDR a severe security risk? How can Security Group rules reference another Security Group directly to enforce least-privilege chaining?
Which AWS certification exam covers this architecture scenario?
This interactive lab maps directly to SAA-C03 (Solutions Architect Associate (SAA)) under Domain 3: Design Secure Architectures.
Do I need an AWS account or credit card to practice this lab?
No. CloudTracer runs a stateful VPC packet engine locally in your browser so you can debug Route Tables, Security Groups, NACLs, and target groups with $0 AWS cloud spend.
Related SAA-C03 Troubleshooting Labs
Locked-Out Security Group Ingress
Add an inbound rule allowing TCP port 80 from 0.0.0.0/0 to the web instance Security Group.…
CLF-03Public Database Exposure Vulnerability
Move or configure RDS to be in a private subnet, disable public accessibility, and restrict ingress exclusively to …
CLF-05S3 Public Access Block Disabled
Enable S3 Block Public Access and enable AES-256 or KMS encryption on the S3 bucket.…
SAA-01FinTech Payment Ledger: $6,750 NAT Gateway S3 Cost Surge
Add an S3 prefix-list destination route in the private route table targeting the S3 Gateway Endpoint.…
SAA-02HealthTech EMR Backend: Asymmetric Outbound NAT Routing
Re-point the private route table default route pointing to NAT (0.0.0.0/0 -> nat-xxx) in the public subnet.…
SAA-03Retail Banking PCI Audit: Stateless NACL Ephemeral Drop
Add an outbound NACL rule permitting return ephemeral traffic (TCP 1024-65535) to 0.0.0.0/0.…