turbot/steampipe-mod-terraform-aws-compliance

Control: DMS replication instances should not be publicly accessible

Description

Manage access to the AWS Cloud by ensuring DMS replication instances cannot be publicly accessed.

Usage

Run the control in your terminal:

powerpipe control run terraform_aws_compliance.control.dms_replication_instance_not_publicly_accessible

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run terraform_aws_compliance.control.dms_replication_instance_not_publicly_accessible --share

SQL

This control uses a named query:

select
address as resource,
case
when (attributes_std -> 'publicly_accessible') is null then 'ok'
when (attributes_std -> 'publicly_accessible')::bool then 'alarm'
else 'ok'
end status,
split_part(address, '.', 2) || case
when (attributes_std -> 'publicly_accessible') is null then ' not publicly accessible'
when (attributes_std -> 'publicly_accessible')::bool then ' publicly accessible'
else ' not publicly accessible'
end || '.' reason
, path || ':' || start_line
from
terraform_resource
where
type = 'aws_dms_replication_instance';

Tags