turbot/oci_insights

Query: identity_policies_for_identity_group

Usage

powerpipe query oci_insights.query.identity_policies_for_identity_group

SQL

select
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;