turbot/aws_insights

Query: iam_users_for_iam_policy

Usage

powerpipe query aws_insights.query.iam_users_for_iam_policy

Steampipe Tables

SQL

select
arn as user_arn
from
aws_iam_user,
jsonb_array_elements_text(attached_policy_arns) as policy_arn
where
policy_arn = $1;