postgresql7.1
delete from
acs_permissions
where
object_id in
(
select bookmark_id from bm_bookmarks
where tree_sortkey like
(
select tree_sortkey || '%'
from bm_bookmarks
where bookmark_id = :root_folder_id
)
)
and grantee_id <> :viewed_user_id
update
acs_objects
set
security_inherit_p = 't'
where
object_id in
(
select bookmark_id from bm_bookmarks
where tree_sortkey like
(
select tree_sortkey || '%'
from bm_bookmarks
where bookmark_id = :root_folder_id
)
)