oracle8.1.6
select a.contact_id,address_id,
delivery_address || '
' || municipality || ' ' || region || ' ' || postal_code as address,
country_code,address_type_id,
acs_permission.permission_p(a.contact_id, :user_id,
'write') as write_p,
acs_permission.permission_p(a.contact_id, :user_id,
'delete') as delete_p
from cn_addresses a, acs_objects o
where a.contact_id = o.object_id
and a.contact_id = :contact_id