oracle8.1.6
select person.name(o.creation_user) as owner,
i.name,
r.title,
content_item.get_path(i.item_id,file_storage.get_root_folder([ad_conn package_id])) as file_path,
acs_permission.permission_p(:file_id,:user_id,'write') as write_p,
acs_permission.permission_p(:file_id,:user_id,'delete') as delete_p,
acs_permission.permission_p(:file_id,:user_id,'admin') as admin_p
from acs_objects o, cr_revisions r, cr_items i
where o.object_id = :file_id
and i.item_id = o.object_id
and r.revision_id = i.live_revision
select r.title,
r.revision_id as version_id,
person.name(o.creation_user) as author,
r.mime_type as type,
to_char(o.last_modified,'YYYY-MM-DD HH24:MI') as last_modified,
r.description,
acs_permission.permission_p(r.revision_id,:user_id,'admin') as admin_p,
acs_permission.permission_p(r.revision_id,:user_id,'delete') as delete_p,
-- dbms_lob.getlength(r.content) as content_size
r.content_length as content_size
from acs_objects o, cr_revisions r
where o.object_id = r.revision_id
and acs_permission.permission_p(r.revision_id, :user_id, 'read') = 't'
$show_versions
and r.item_id = :file_id
and r.revision_id = (select live_revision from cr_items where item_id = :file_id)