oracle 8.1.6
select n.template_demo_note_id, n.title, n.body, decode(acs_permission.permission_p(n.template_demo_note_id, :user_id, 'write'), 't', 1, 'f', 0) as write_p, decode(acs_permission.permission_p(n.template_demo_note_id, :user_id, 'admin'), 't', 1, 'f', 0) as admin_p, decode(acs_permission.permission_p(n.template_demo_note_id, :user_id, 'delete'), 't', 1, 'f', 0) as delete_p from template_demo_notes n, acs_objects o where n.template_demo_note_id = o.object_id and exists (select 1 from acs_object_party_privilege_map where object_id = n.template_demo_note_id and party_id = :user_id and privilege = 'read') order by creation_date