turbot/aws_insights

Query: iam_policies_for_iam_user

Usage

powerpipe query aws_insights.query.iam_policies_for_iam_user

Steampipe Tables

SQL

select
jsonb_array_elements_text(attached_policy_arns) as policy_arn
from
aws_iam_user
where
arn = $1
and account_id = split_part($1, ':', 5);