https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41045 --- Comment #11 from Fridolin Somers <fridolin.somers@biblibre.com> --- (In reply to David Cook from comment #9)
(In reply to David Cook from comment #8)
Note I'm going to immediately backport this patch locally myself... and I'm planning on writing some queries to find any users with that have only "suggestions_create" and "suggestions_delete" but not "suggestions_manage"...
There's probably a better way to do this, but this is the query I used in the end:
select borrowernumber,group_concat(code) as perms from user_permissions where module_bit = 12 group by borrowernumber having perms like '%suggestions_create%' and perms like '%suggestions_delete%' and perms not like '%suggestions_manage%' ;
It's possible that some users legitimately had that set of permissions, but it seemed unlikely to me, so I wrote a Perl script to blitz them.
You can add sort by code to this SQL so that result is easier to read : select borrowernumber,group_concat(code order by code) as perms from user_permissions where module_bit = 12 group by borrowernumber having perms like '%suggestions_create%' and perms like '%suggestions_delete%' and perms not like '%suggestions_manage%' -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.