Control: Ensure that Separation of duties is enforced while assigning service account related roles to users
Description
It is recommended that the principle of 'Separation of Duties' is enforced while assigning service-account related roles to users.
Usage
Run the control in your terminal:
powerpipe control run gcp_compliance.control.iam_user_separation_of_duty_enforced
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run gcp_compliance.control.iam_user_separation_of_duty_enforced --share
SQL
This control uses a named query:
with users_with_roles as ( select distinct split_part(member_entity, ':', 2) as user_name, project, _ctx, p ->> 'role' as assigned_role from gcp_iam_policy, jsonb_array_elements(bindings) as p, jsonb_array_elements_text(p -> 'members') as member_entity where split_part(member_entity, ':', 1) = 'user'),account_admin_users as( select user_name, project from users_with_roles where assigned_role = 'roles/iam.serviceAccountAdmin'),account_users as( select user_name, project from users_with_roles where assigned_role = 'roles/iam.serviceAccountUser')select distinct user_name as resource, case when user_name in (select user_name from account_users) and user_name in (select user_name from account_admin_users) then 'alarm' else 'ok' end as status, case when user_name in (select user_name from account_users) and user_name in (select user_name from account_admin_users) then user_name || ' assigned with both Service Account Admin and Service Account User roles.' else user_name || ' not assigned with both Service Account Admin and Service Account User roles.' end as reason , project as projectfrom users_with_roles;