Re: Gallery Permissions query/report
Just in case anyone is curious, I spent a little more time, discovered that lib/userslib.php function object_has_permission forms objectId's by md5'ing a concatentation of 'objectType' string and 'obJectId' to make the objectId used by table users_objectpermissions, thus the query (in postgres syntax) for my requirements is as follows....
select b.name, a."groupName", a."permName" from users_objectpermissions a, tiki_file_galleries b where a."objectId"=md5('file gallery' || b."galleryId") order by b.name, a."groupName", a."permName";