Control: AWS Redshift clusters should not use the default Admin username
Description
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.
Usage
Run the control in your terminal:
powerpipe control run aws_compliance.control.redshift_cluster_no_default_admin_nameSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_compliance.control.redshift_cluster_no_default_admin_name --shareSQL
This control uses a named query:
select arn as resource, case when master_username = 'awsuser' then 'alarm' else 'ok' end as status, case when master_username = 'awsuser' then title || ' using default master user name.' else title || ' not using default master user name.' end as reason , region, account_idfrom aws_redshift_cluster;