Query: List IAM roles that have policies allowing all (*) actions.

Description

Identify instances where IAM roles have policies that permit all actions. This can be useful in auditing security settings to ensure that no roles have overly broad permissions, which could pose a security risk.Use this query to identify which AWS IAM roles and their respective policies allow all actions, in order to assess potential security concerns.

Query

Tables used in this query:

• aws_iam_role

SQL