Query: Ensure IAM users are assigned access keys and passwords at setup

Description

This control checks whether the IAM users have access keys and passwords at setup. The control fails if the IAM users do not have access keys and passwords at setup.

Query

Tables used in this query:

• aws_iam_credential_report

Controls using this query:

• 1.10 Do not create access keys during initial setup for IAM users with a console password
• 1.11 Do not create access keys during initial setup for IAM users with a console password
• 1.11 Do not setup access keys during initial user setup for all IAM users that have a console password
• 1.11 Do not setup access keys during initial user setup for all IAM users that have a console password
• 1.11 Do not setup access keys during initial user setup for all IAM users that have a console password
• 1.11 Do not setup access keys during initial user setup for all IAM users that have a console password
• 1.11 Do not setup access keys during initial user setup for all IAM users that have a console password
• 1.21 Do not setup access keys during initial user setup for all IAM users that have a console password
• 2.10 Do not create access keys during initial setup for IAM users with a console password
• Ensure IAM users are assigned access keys and passwords at setup

SQL