turbot/steampipe-mod-aws-compliance

Control: IAM users should be in at least one group

Description

AWS Identity and Access Management (IAM) can help you restrict access permissions and authorizations, by ensuring IAM users are members of at least one group.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.iam_user_in_group

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run aws_compliance.control.iam_user_in_group --share

SQL

This control uses a named query:

select
arn as resource,
case
when jsonb_array_length(groups) = 0 then 'alarm'
else 'ok'
end as status,
case
when jsonb_array_length(groups) = 0 then title || ' not associated with any IAM group.'
else title || ' associated with IAM group.'
end as reason
, account_id
from
aws_iam_user;

Tags