Query: IAM policy should be in use

Description

This control checks whether the IAM policy ARN is 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 policy should be in use

SQL