turbot/oci_insights

Query: identity_users_for_identity_group

Usage

powerpipe query oci_insights.query.identity_users_for_identity_group

Steampipe Tables

SQL

select
id as user_id
from
oci_identity_user,
jsonb_array_elements(user_groups) as gid
where
gid ->> 'groupId' = $1;