oracle8.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