Query: IAM customer managed policy should be in use

Description

This control checks whether customer managed IAM policies are attached to an IAM user, or a group with one or more IAM users, or an IAM role with one or more trusted entity.

Query

Tables used in this query:

• aws_iam_group
• aws_iam_policy
• aws_iam_role
• aws_iam_user

Controls using this query:

• IAM customer managed policy should be in use

SQL