AWS Redshift clusters should not use the default Admin username¶

This control checks whether a AWS Redshift cluster has changed the admin username from its default value. This control will fail if the admin username for a Redshift cluster is set to awsuser.

How to fix¶

Attribute master_username of aws_redshift_cluster must be non-empty.

Implementation options¶

Choose the option that matches how you manage Terraform. All options satisfy this control.

Option 1: Compliance.tf module (recommended)¶

Use the compliance.tf registry module to get this control enforced by default. This control is mapped to the frameworks shown in the tabs above. To begin, see get started with compliance.tf.

module "redshift" {
  source  = "nistcsfv11.compliance.tf/terraform-aws-modules/redshift/aws"
  version = ">=7.0.0,<8.0.0"

  cluster_identifier     = "abc123"
  database_name          = "mydb"
  master_password_wo     = "change-me-in-production"
  master_username        = "admin"
  node_type              = "dc2.large"
  number_of_nodes        = 1
  subnet_ids             = []
  vpc_security_group_ids = []
}

module "redshift" {
  source  = "pcidssv321.compliance.tf/terraform-aws-modules/redshift/aws"
  version = ">=7.0.0,<8.0.0"

  cluster_identifier     = "abc123"
  database_name          = "mydb"
  master_password_wo     = "change-me-in-production"
  master_username        = "admin"
  node_type              = "dc2.large"
  number_of_nodes        = 1
  subnet_ids             = []
  vpc_security_group_ids = []
}

Option 2: Open source module (terraform-aws-modules)¶

If you use terraform-aws-modules/redshift/aws, configure the required module inputs to satisfy this control. You can later migrate to the compliance.tf module with minimal changes because it is compatible by design.

module "redshift" {
  source  = "terraform-aws-modules/redshift/aws"
  version = ">=7.0.0,<8.0.0"

  cluster_identifier     = "abc123"
  database_name          = "mydb"
  master_password_wo     = "change-me-in-production"
  master_username        = "admin"
  node_type              = "dc2.large"
  number_of_nodes        = 1
  subnet_ids             = []
  vpc_security_group_ids = []
}

Option 3: Terraform AWS provider resources¶

If you manage resources directly, configure the relevant Terraform AWS provider resources to meet this control. See docs for the resources involved: aws_redshift_cluster.

resource "aws_redshift_cluster" "this" {
  automated_snapshot_retention_period = 7
  cluster_identifier                  = "pofix-example"
  master_password                     = "ChangeMe123!"
  master_username                     = "admin"
  node_type                           = "dc2.large"
  skip_final_snapshot                 = true
}

Tool mappings¶

Use these identifiers to cross-reference this control across tools, reports, and evidence.

• Compliance.tf (CTF) Control: redshift_cluster_no_default_admin_name

• AWS Config Managed Rule: REDSHIFT_DEFAULT_ADMIN_CHECK

• Powerpipe Control: aws_compliance.control.redshift_cluster_no_default_admin_name