Query: oracle_autonomous_database_not_publicly_accessible

select
  d.id as resource,
  case
    when whitelisted_ips is null then 'alarm'
    else 'ok'
  end as status,
  case
    when whitelisted_ips is null then d.title || ' is publicly accessible.'
    else d.title || ' not publicly accessible.'
  end as reason,
  d.region as region,
  d.tenant_name as tenant,
  coalesce(c.name, 'root') as compartment
from
  oci_database_autonomous_database as d
  left join oci_identity_compartment as c on c.id = d.compartment_id;