By sylvie on 05/21/09 07:10 EDT
How to know which objects have a special permission for a group
If you want to know on which wiki page or which file gallery an Anonymous has special perm
SELECT pageName FROM tiki_pages
WHERE md5( concat( 'wiki page', pageName ) ) in (select objectid from users_objectpermissions where groupName='Anonymous' and objectType='wiki page');
SELECT name, galleryId FROM tiki_file_galleries
WHERE md5( concat( 'file gallery', galleryId ) ) in (select objectid from users_objectpermissions where groupName='Anonymous' and objectType='file gallery');
