View | Details | Raw Unified | Return to bug 14391
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug14391_granular_admin_permissions.sql (-4 lines)
Lines 75-82 INSERT INTO user_permissions (borrowernumber, module_bit, code) Link Here
75
    WHERE borrowernumber IN
75
    WHERE borrowernumber IN
76
        (SELECT borrowernumber FROM user_permissions WHERE code = 'catalogue');
76
        (SELECT borrowernumber FROM user_permissions WHERE code = 'catalogue');
77
77
78
/* Clean up now obsolete permission */
79
DELETE FROM user_permissions WHERE module_bit = 3 and code = 'parameters_remaining_permissions';
80
DELETE FROM permissions WHERE module_bit = 3 and code = 'parameters_remaining_permissions';
81
82
-- Bug 14391: Add granular permissions to the administration module
78
-- Bug 14391: Add granular permissions to the administration module
(-)a/installer/data/mysql/userpermissions.sql (-1 / +1 lines)
Lines 5-10 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
5
   ( 1, 'force_checkout', 'Force checkout if a limitation exists'),
5
   ( 1, 'force_checkout', 'Force checkout if a limitation exists'),
6
   ( 1, 'manage_restrictions', 'Manage restrictions for accounts'),
6
   ( 1, 'manage_restrictions', 'Manage restrictions for accounts'),
7
   ( 1, 'manage_checkout_notes', 'Mark checkout notes as seen/not seen'),
7
   ( 1, 'manage_checkout_notes', 'Mark checkout notes as seen/not seen'),
8
   ( 3, 'parameters_remaining_permissions', 'Remaining system parameters permissions'),
8
   ( 3, 'manage_circ_rules', 'Manage circulation rules'),
9
   ( 3, 'manage_circ_rules', 'Manage circulation rules'),
9
   ( 3, 'manage_circ_rules_from_any_libraries', 'Manage circ rules for any libraries'),
10
   ( 3, 'manage_circ_rules_from_any_libraries', 'Manage circ rules for any libraries'),
10
   ( 3, 'manage_sysprefs', 'Manage global system preferences'),
11
   ( 3, 'manage_sysprefs', 'Manage global system preferences'),
11
- 

Return to bug 14391