permissions-reset-all-2-postgresql.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="delete_individual_permissions">      
      <querytext>

delete from 
	acs_permissions 
where 
	object_id in 
	(
	select bm.bookmark_id from bm_bookmarks bm, bm_bookmarks bm2
	where bm.tree_sortkey between bm2.tree_sortkey and tree_right(bm2.tree_sortkey)
          and bm2.bookmark_id = :root_folder_id
	)
and grantee_id <> :viewed_user_id
      </querytext>
</fullquery>

 
<fullquery name="turn_on_security_inheritance">      
      <querytext>

update 
	acs_objects 
set 
	security_inherit_p = 't'
where 
	object_id in 
	(
	select bookmark_id from bm_bookmarks bm, bm_bookmarks bm2
	where bm.tree_sortkey between bm2.tree_sortkey and tree_right(bm2.tree_sortkey)
          and bm2.bookmark_id = :root_folder_id
	)

      </querytext>
</fullquery>

 
</queryset>