Query: Ensure there is only one active access key available for any single IAM user

Description

Access keys are long-term credentials for an IAM user or the AWS account root user. You can use access keys to sign programmatic requests to the AWS CLI or AWS API (directly or using the AWS SDK).

Query

Tables used in this query:

• aws_iam_access_key
• aws_iam_user

Controls using this query:

• 1.12 Ensure there is only one active access key for any single IAM user
• 1.13 Ensure there is only one active access key available for any single IAM user
• 1.13 Ensure there is only one active access key available for any single IAM user
• 1.13 Ensure there is only one active access key available for any single IAM user
• 1.13 Ensure there is only one active access key available for any single IAM user
• 1.13 Ensure there is only one active access key available for any single IAM user
• 1.13 Ensure there is only one active access key for any single IAM user
• 2.12 Ensure there is only one active access key for any single IAM user
• Ensure there is only one active access key available for any single IAM user

SQL