Query: iam_organization_use_basic_role

select
  address as resource,
  case
    when (attributes_std ->> 'role') like any (
      array [ 'roles/owner',
      'roles/editor',
      'roles/viewer' ]
    ) then 'alarm'
    else 'ok'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std ->> 'role') like any (
      array [ 'roles/owner',
      'roles/editor',
      'roles/viewer' ]
    ) then ' uses basic role'
    else ' does not use basic role'
  end || '.' reason,
  path || ':' || start_line
from
  terraform_resource
where
  type in (
    'google_organization_iam_member',
    'google_organization_iam_binding'
  );