Hi Katrin You wrote:
this will work as long as you only assign 'module/top level permissions. As soon as you only assign some sub-permissions of a module to a user, you'll also need the entries from the user_permissions table.
Yes, you are right. To circumvent this problem it is necessary to do the following. 1. Find the borrowernumber (here: 11) of a patron which has the desired patron permissions, then search for the patron permissions of this patron: SELECT flags FROM borrowers WHERE borrowernumber=11; 2. The result will show the number associated with the staff member’s permissions, for example: +-------+ | flags | +-------+ | 16900 | +-------+ 3. Then update the field "flags" of a new patron (here with borrowernumber 12) which currently has no permissions but which should receive the same top level permissions as the original patron: UPDATE borrowers SET flags=16900 WHERE borrowernumber=12; 4. Update the fields in table "user_permissions" of this patron (here with borrowernumber 12) which should also receive the same sub-permissions as the original patron (here with borrowernumber 11): INSERT INTO user_permissions (borrowernumber, module_bit, code) SELECT 12, module_bit, code FROM user_permissions WHERE borrowernumber=11; I have tested this successfully on my demo installation. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch