AWSOverview
If you have to or choose to host the database on a virtual machine, encrypting the volumes is highly recommended.
The system determines this based on the VM name.
Remediation guidance
AWS remediation
Console
- Identify unencrypted attached EBS volumes.
- Snapshot each unencrypted volume.
- Copy snapshots with encryption enabled.
- Create encrypted volumes and replace old volumes in maintenance window.
AWS CLI
aws ec2 enable-ebs-encryption-by-default
aws ec2 create-snapshot --volume-id <volume-id> --description "migrate-to-encrypted"
aws ec2 copy-snapshot --source-region <region> --source-snapshot-id <snapshot-id> --encrypted --kms-key-id <kms-key-id>
aws ec2 create-volume --availability-zone <az> --snapshot-id <encrypted-snapshot-id> --encrypted --kms-key-id <kms-key-id>
References
- https://docs.aws.amazon.com/ebs/latest/userguide/ebs-encryption.html
- https://docs.aws.amazon.com/ebs/latest/userguide/encryption-by-default.html
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.
Encrypted storage is used for VMs that might host a database
Connectors
AWS
Covered asset types
VM
Expected check: eq []
{vms(where:{diskAttachments_SOME:{disk:{encrypted:false}},OR:[{name_MATCHES:"(?i).*database.*"},{name_MATCHES:"(?i).*db.*"},{name_MATCHES:"(?i).*mariadb.*"},{name_MATCHES:"(?i).*postgres.*"},{name_MATCHES:"(?i).*oracle.*"},{name_MATCHES:"(?i).*sql.*"}]}){...AssetFragment}}
