Gallery Permissions query/report
Hi all,
I've been asked to produce a report which details all permissions/groups granted to each of our tiki file galleries...
The below query (postgres) very nearly gives me what I need, but it seems that "objectId" column needs to relate to a column in the table tiki_file_galleries table, but does not (IOW, my goial is to add the "name" column from table tiki_file_galleries to the results of below query...)
select "groupName", "permName", "objectId" from users_objectpermissions where "objectType"='file gallery' order by "objectId", "groupName";
Any help/insigth appreciated.
Wayne Beaver