turbot/aws_insights

Query: iam_roles_for_iam_policy

Usage

powerpipe query aws_insights.query.iam_roles_for_iam_policy

Steampipe Tables

SQL

select
arn as role_arn
from
aws_iam_role,
jsonb_array_elements_text(attached_policy_arns) as policy_arn
where
policy_arn = $1;