Lines 1-78
Link Here
|
1 |
INSERT INTO permissions (module_bit, code, description) VALUES |
|
|
2 |
( 3, 'manage_sysprefs', 'Manage global system preferences'), |
3 |
( 3, 'manage_libraries', 'Manage libraries and library groups'), |
4 |
( 3, 'manage_itemtypes', 'Manage item types'), |
5 |
( 3, 'manage_auth_values', 'Manage authorized values'), |
6 |
( 3, 'manage_patron_categories', 'Manage patron categories'), |
7 |
( 3, 'manage_patron_attributes', 'Manage extended patron attributes'), |
8 |
( 3, 'manage_transfers', 'Manage library transfer limits and transport cost matrix'), |
9 |
( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'), |
10 |
( 3, 'manage_cities', 'Manage cities and towns'), |
11 |
( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'), |
12 |
( 3, 'manage_keywords2koha_mappings', 'Manage keywords to Koha mappings'), |
13 |
( 3, 'manage_classifications', 'Manage classification sources'), |
14 |
( 3, 'manage_matching_rules', 'Manage record matching rules'), |
15 |
( 3, 'manage_oai_sets', 'Manage OAI sets'), |
16 |
( 3, 'manage_item_search_fields', 'Manage item search fields'), |
17 |
( 3, 'manage_search_engine_config', 'Manage search engine configuration'), |
18 |
( 3, 'manage_search_targets', 'Manage Z39.50 and SRU server configuration'), |
19 |
( 3, 'manage_didyoumean', 'Manage Did you mean? configuration'), |
20 |
( 3, 'manage_column_config', 'Manage column configuration'), |
21 |
( 3, 'manage_sms_providers', 'Manage SMS cellular providers'), |
22 |
( 3, 'manage_audio_alerts', 'Manage audio alerts'), |
23 |
( 3, 'manage_usage_stats', 'Manage usage statistics settings'); |
24 |
|
25 |
/* User has parameters_remaining_permissions */ |
26 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
27 |
SELECT borrowernumber, 3, 'manage_sysprefs' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
28 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
29 |
SELECT borrowernumber, 3, 'manage_libraries' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
30 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
31 |
SELECT borrowernumber, 3, 'manage_itemtypes' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
32 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
33 |
SELECT borrowernumber, 3, 'manage_auth_values' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
34 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
35 |
SELECT borrowernumber, 3, 'manage_patron_categories' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
36 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
37 |
SELECT borrowernumber, 3, 'manage_patron_attributes' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
38 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
39 |
SELECT borrowernumber, 3, 'manage_transfers' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
40 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
41 |
SELECT borrowernumber, 3, 'manage_item_circ_alerts' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
42 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
43 |
SELECT borrowernumber, 3, 'manage_cities' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
44 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
45 |
SELECT borrowernumber, 3, 'manage_marc_frameworks' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
46 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
47 |
SELECT borrowernumber, 3, 'manage_keywords2koha_mappings' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
48 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
49 |
SELECT borrowernumber, 3, 'manage_classifications' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
50 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
51 |
SELECT borrowernumber, 3, 'manage_matching_rules' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
52 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
53 |
SELECT borrowernumber, 3, 'manage_oai_sets' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
54 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
55 |
SELECT borrowernumber, 3, 'manage_item_search_fields' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
56 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
57 |
SELECT borrowernumber, 3, 'manage_search_engine_config' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
58 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
59 |
SELECT borrowernumber, 3, 'manage_search_targets' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
60 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
61 |
SELECT borrowernumber, 3, 'manage_didyoumean' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
62 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
63 |
SELECT borrowernumber, 3, 'manage_column_config' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
64 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
65 |
SELECT borrowernumber, 3, 'manage_sms_providers' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
66 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
67 |
SELECT borrowernumber, 3, 'manage_audio_alerts' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
68 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
69 |
SELECT borrowernumber, 3, 'manage_usage_stats' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); |
70 |
|
71 |
/* User has catalogue permission */ |
72 |
INSERT INTO user_permissions (borrowernumber, module_bit, code) |
73 |
SELECT borrowernumber, 3, 'manage_item_search_fields' |
74 |
FROM borrowers |
75 |
WHERE borrowernumber IN |
76 |
(SELECT borrowernumber FROM user_permissions WHERE code = 'catalogue'); |
77 |
|
78 |
-- Bug 14391: Add granular permissions to the administration module |
79 |
- |