turbot/oci_insights

Query: identity_policies_for_group

Usage

powerpipe query oci_insights.query.identity_policies_for_group

SQL

select
distinct p.name as "Policy Name",
p.id as "Policy ID"
from
oci_identity_policy as p,
jsonb_array_elements_text(statements) as s,
oci_identity_group as g
where
s ilike '%' || g.name || '%'
and g.id = $1;

Dashboards

The query is used in the dashboards: