Query: objectstorage_bucket_public_access_status

with public_access_stat as (
  select
    case
      when public_access_type = 'NoPublicAccess' then 'disabled'
      else 'enabled'
    end as public_access_stat
  from
    oci_objectstorage_bucket
)
select
  public_access_stat,
  count(*)
from
  public_access_stat
group by
  public_access_stat