Query: storage_bucket_public_access

select
  'Public Access' as label,
  case
    when iam_policy ->> 'bindings' like any (array [ '%allAuthenticatedUsers%', '%allUsers%' ]) then 'Enabled'
    else 'Disabled'
  end as value,
  case
    when iam_policy ->> 'bindings' like any (array [ '%allAuthenticatedUsers%', '%allUsers%' ]) then 'alert'
    else 'ok'
  end as type
from
  gcp_storage_bucket
where
  id = $1;