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

Description

This control checks if all AWS managed policies specified in the list of managed policies are attached to the AWS Identity and Access Management (IAM) role. The rule is non-compliant if an AWS managed policy is not attached to the IAM role.

Query

Tables used in this query:

• aws_iam_policy
• aws_iam_role

Controls using this query:

• IAM AWS managed policies should be attached to IAM role

SQL