turbot/steampipe-mod-aws-compliance

Control: IAM users with console access should have MFA enabled

Description

Manage access to resources in the AWS Cloud by ensuring that MFA is enabled for all AWS Identity and Access Management (IAM) users that have a console password.

Usage

Run the control in your terminal:

powerpipe control run aws_compliance.control.iam_user_console_access_mfa_enabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
user_arn as resource,
case
when password_enabled and not mfa_active then 'alarm'
else 'ok'
end as status,
case
when not password_enabled then user_name || ' password login disabled.'
when password_enabled and not mfa_active then user_name || ' password login enabled but no MFA device configured.'
else user_name || ' password login enabled and MFA device configured.'
end as reason
, account_id
from
aws_iam_credential_report;

Tags