turbot/tailpipe-mod-aws-cloudtrail-log-detections

Detection: IAM Group Administrator Policy Attached

Overview

Detect when the AdministratorAccess policy was attached to an IAM group. Assigning this policy grants all group members full access to AWS resources, increasing the risk of unauthorized privilege escalation, security misconfigurations, or potential misuse. Monitoring these actions ensures that administrative permissions are only assigned when necessary and adheres to the principle of least privilege.

References:

Usage

Run the detection in your terminal:

powerpipe detection run aws_cloudtrail_log_detections.detection.iam_group_administrator_policy_attached

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe detection run aws_cloudtrail_log_detections.detection.iam_group_administrator_policy_attached --share

SQL

This detection uses a named query:

select
tp_timestamp as timestamp,
string_split(event_source, '.')[1] || ':' || event_name as operation,
request_parameters ->> 'groupName' as resource,
user_identity.arn as actor,
tp_source_ip as source_ip,
tp_index as account_id,
aws_region as region,
tp_id as source_id,
*
from
aws_cloudtrail_log
where
event_source = 'iam.amazonaws.com'
and event_name = 'AttachGroupPolicy'
and (request_parameters ->> 'policyArn') like 'arn:%:iam::aws:policy/AdministratorAccess'
and error_code is null
order by
event_time desc;

Tags