oracle
8.1.6
select fs.object_id, fs.name,
acs_permission.permission_p(fs.object_id, :user_id, 'write') as move_p
from fs_objects fs
where fs.object_id in ([template::util::tcl_to_sql_list $object_id])
order by move_p
select content_item.move(
:one_item,
:folder_id
)
select
cf.folder_id, cf.label, ci1.level
from cr_folders cf, (select item_id, level from
cr_items
connect by prior item_id=parent_id
start with :root_folder_id
) ci1
where
ci1.item_id=cf.folder_id
and exists (select 1
from acs_object_party_privilege_map m
where m.object_id = cf.folder_id
and m.party_id = :user_id
and m.privilege = 'write')
order by order by ci1.level, cf.label