Query: IAM user access keys should be rotated at least every 90 days

Description

The credentials are audited for authorized devices, users, and processes by ensuring IAM access keys are rotated as per organizational policy.

Query

Tables used in this query:

• aws_iam_access_key

Controls using this query:

• 1.14 Ensure access keys are rotated every 90 days or less
• 1.14 Ensure access keys are rotated every 90 days or less
• 1.14 Ensure access keys are rotated every 90 days or less
• 1.14 Ensure access keys are rotated every 90 days or less
• 1.14 Ensure access keys are rotated every 90 days or less
• 1.14 Ensure access keys are rotated every 90 days or less
• 1.4 Ensure access keys are rotated every 90 days or less
• 3 IAM users' access keys should be rotated every 90 days or less
• IAM user access keys should be rotated at least every 90 days

SQL