turbot/kubernetes_insights

Query: service_account_rules_detail

Usage

powerpipe query kubernetes_insights.query.service_account_rules_detail

SQL

select
r -> 'verbs' as "Verbs",
r -> 'apiGroups' as "API Groups",
r -> 'resources' as "Resources",
r -> 'resourceNames' as "Resource Names"
from
kubernetes_service_account,
jsonb_array_elements(rules) as r
where
uid = $1;

Params

ArgsNameDefaultDescriptionVariable
$1uid