turbot/aws_insights

Query: iam_groups_for_iam_user

Usage

powerpipe query aws_insights.query.iam_groups_for_iam_user

Steampipe Tables

SQL

select
g ->> 'Arn' as group_arn
from
aws_iam_user,
jsonb_array_elements(groups) as g
where
arn = $1
and account_id = split_part($1, ':', 5);