turbot/aws_insights

Query: iam_groups_for_iam_policy

Usage

powerpipe query aws_insights.query.iam_groups_for_iam_policy

Steampipe Tables

SQL

select
arn as group_arn
from
aws_iam_group,
jsonb_array_elements_text(attached_policy_arns) as policy_arn
where
policy_arn = $1;