[Koha-bugs] [Bug 41045] Suggestions manage permissions added to patrons who previously had no permissions in that category

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41045 --- Comment #13 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to Eric Phetteplace from comment #12)

Note for folks trying to use this SQL in a report; it contains the SQL keywords create and delete which are not allowed, so you can to work around them with CONCAT:

select borrowernumber,group_concat(code order by code) as perms from user_permissions where module_bit = 12 group by borrowernumber having perms like CONCAT('%suggestions_cr','eate%') and perms like CONCAT('%suggestions_de','lete%') and perms not like '%suggestions_manage%'

Haha, nice :) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.