Send blog post

Send post to this addresses

List of email addresses separated by commas
How to know which objects have a special permission for a group
Posted by sylvie on 05/21/09 07:10 EDT
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');



Permalink (referenced by: Posts references: Posts) Print Email This Post