turbot/steampipe-mod-gcp-compliance

Control: Compute Instances should restrict service account impersonate permission

Description

This control ensures that Compute Instance does not allow service account impersonate permissions.

Usage

Run the control in your terminal:

powerpipe control run gcp_compliance.control.compute_instance_no_service_account_impersonate_permission

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run gcp_compliance.control.compute_instance_no_service_account_impersonate_permission --share

SQL

This control uses a named query:

with role_with_service_account_impersonate_permission as (
select
distinct name,
project
from
gcp_iam_role,
jsonb_array_elements_text(included_permissions) as p
where
not is_gcp_managed
and p in (
'iam.serviceAccounts.getAccessToken',
'iam.serviceAccounts.signBlob',
'iam.serviceAccounts.signJwt',
'iam.serviceAccounts.implicitDelegation',
'iam.serviceAccounts.getOpenIdToken',
'iam.serviceAccounts.actAs'
)
),
policy_with_service_account_impersonate_permission as (
select
distinct entity,
project
from
gcp_iam_policy,
jsonb_array_elements(bindings) as p,
jsonb_array_elements_text(p -> 'members') as entity
where
p ->> 'role' in ('roles/iam.securityAdmin')
or p ->> 'role' in (
select
name
from
role_with_service_account_impersonate_permission
)
),
compute_instance_with_service_account_impersonate_permission as (
select
distinct self_link
from
gcp_compute_instance as i,
jsonb_array_elements(service_accounts) as e
left join policy_with_service_account_impersonate_permission as b on b.entity = concat('serviceAccount:' || (e ->> 'email'))
where
b.entity is not null
)
select
i.self_link as resource,
case
when p.self_link is not null then 'alarm'
else 'ok'
end as status,
case
when p.self_link is not null then i.title || ' allow service account impersonate permission.'
else i.title || ' restrict service account impersonate permission.'
end as reason,
location as location,
project as project
from
gcp_compute_instance as i
left join compute_instance_with_service_account_impersonate_permission as p on p.self_link = i.self_link;

Tags