Query: IAM customer managed policies should be attached to IAM role

Description

This control checks if customer managed IAM policies are attached to an AWS Identity and Access Management (IAM) role. The rule is non-compliant if a customer managed IAM policy is not attached to any IAM role.

Query

Tables used in this query:

• aws_iam_policy
• aws_iam_role

Controls using this query:

• IAM customer managed policies should be attached to IAM role

SQL