oracle8.1.6
select p.public_p,
p.pres_title as presentation_title,
acs_permission.permission_p(:pres_item_id, :user_id, 'wp_admin_presentation') as admin_p,
acs_permission.permission_p(:pres_item_id, :user_id, 'wp_delete_presentation') as delete_p,
ao.creation_user,
p.show_comments_p,
p.presentation_id
from cr_wp_presentations p,
cr_items i,
acs_objects ao
where i.item_id = :pres_item_id
and i.live_revision = p.presentation_id
and ao.object_id = :pres_item_id
select distinct (p.person_id),
p.first_names || ' ' || p.last_name as full_name,
perm.privilege
from persons p,
acs_permissions perm
where perm.object_id = :pres_item_id
and perm.grantee_id = p.person_id
and
(perm.privilege = 'wp_view_presentation'
or perm.privilege = 'wp_edit_presentation'
or perm.privilege = 'wp_admin_presentation'
)
order by p.person_id, perm.privilege ASC