Bugzilla – Attachment 81452 Details for
Bug 14391
Granular permissions for the administration module
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14391: (QA follow-up) Correct database update for manage_item_search_fields permission
Bug-14391-QA-follow-up-Correct-database-update-for.patch (text/plain), 9.22 KB, created by
Katrin Fischer
on 2018-10-29 06:59:18 UTC
(
hide
)
Description:
Bug 14391: (QA follow-up) Correct database update for manage_item_search_fields permission
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2018-10-29 06:59:18 UTC
Size:
9.22 KB
patch
obsolete
>From 3bdbe82171ea33aa709e8faf4e48bdc785066114 Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <katrin.fischer.83@web.de> >Date: Sun, 28 Oct 2018 19:03:56 +0000 >Subject: [PATCH] Bug 14391: (QA follow-up) Correct database update for > manage_item_search_fields permission > >--- > .../bug14391_granular_admin_permissions.perl | 5 +- > .../bug14391_granular_admin_permissions.sql | 78 ---------------------- > 2 files changed, 1 insertion(+), 82 deletions(-) > delete mode 100644 installer/data/mysql/atomicupdate/bug14391_granular_admin_permissions.sql > >diff --git a/installer/data/mysql/atomicupdate/bug14391_granular_admin_permissions.perl b/installer/data/mysql/atomicupdate/bug14391_granular_admin_permissions.perl >index f74d5ac057..9b6a9ccf0d 100644 >--- a/installer/data/mysql/atomicupdate/bug14391_granular_admin_permissions.perl >+++ b/installer/data/mysql/atomicupdate/bug14391_granular_admin_permissions.perl >@@ -115,10 +115,7 @@ if( CheckVersion( $DBversion ) ) { > }); > $dbh->do(q{ > INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_item_search_fields' >- FROM borrowers >- WHERE borrowernumber IN >- (SELECT borrowernumber FROM user_permissions WHERE code = 'catalogue'); >+ SELECT borrowernumber, 3, 'manage_item_search_fields' FROM borrowers WHERE flags & (1 << 2); > }); > SetVersion( $DBversion ); > print "Upgrade to $DBversion done (Bug 14391: Add granular permissions to the administration module)\n"; >diff --git a/installer/data/mysql/atomicupdate/bug14391_granular_admin_permissions.sql b/installer/data/mysql/atomicupdate/bug14391_granular_admin_permissions.sql >deleted file mode 100644 >index 7aabf7c61a..0000000000 >--- a/installer/data/mysql/atomicupdate/bug14391_granular_admin_permissions.sql >+++ /dev/null >@@ -1,78 +0,0 @@ >-INSERT INTO permissions (module_bit, code, description) VALUES >- ( 3, 'manage_sysprefs', 'Manage global system preferences'), >- ( 3, 'manage_libraries', 'Manage libraries and library groups'), >- ( 3, 'manage_itemtypes', 'Manage item types'), >- ( 3, 'manage_auth_values', 'Manage authorized values'), >- ( 3, 'manage_patron_categories', 'Manage patron categories'), >- ( 3, 'manage_patron_attributes', 'Manage extended patron attributes'), >- ( 3, 'manage_transfers', 'Manage library transfer limits and transport cost matrix'), >- ( 3, 'manage_item_circ_alerts', 'Manage item circulation alerts'), >- ( 3, 'manage_cities', 'Manage cities and towns'), >- ( 3, 'manage_marc_frameworks', 'Manage MARC bibliographic and authority frameworks'), >- ( 3, 'manage_keywords2koha_mappings', 'Manage keywords to Koha mappings'), >- ( 3, 'manage_classifications', 'Manage classification sources'), >- ( 3, 'manage_matching_rules', 'Manage record matching rules'), >- ( 3, 'manage_oai_sets', 'Manage OAI sets'), >- ( 3, 'manage_item_search_fields', 'Manage item search fields'), >- ( 3, 'manage_search_engine_config', 'Manage search engine configuration'), >- ( 3, 'manage_search_targets', 'Manage Z39.50 and SRU server configuration'), >- ( 3, 'manage_didyoumean', 'Manage Did you mean? configuration'), >- ( 3, 'manage_column_config', 'Manage column configuration'), >- ( 3, 'manage_sms_providers', 'Manage SMS cellular providers'), >- ( 3, 'manage_audio_alerts', 'Manage audio alerts'), >- ( 3, 'manage_usage_stats', 'Manage usage statistics settings'); >- >-/* User has parameters_remaining_permissions */ >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_sysprefs' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_libraries' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_itemtypes' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_auth_values' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_patron_categories' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_patron_attributes' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_transfers' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_item_circ_alerts' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_cities' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_marc_frameworks' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_keywords2koha_mappings' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_classifications' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_matching_rules' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_oai_sets' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_item_search_fields' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_search_engine_config' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_search_targets' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_didyoumean' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_column_config' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_sms_providers' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_audio_alerts' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_usage_stats' FROM borrowers WHERE borrowernumber IN (SELECT borrowernumber FROM user_permissions WHERE code = 'parameters_remaining_permissions'); >- >-/* User has catalogue permission */ >-INSERT INTO user_permissions (borrowernumber, module_bit, code) >- SELECT borrowernumber, 3, 'manage_item_search_fields' >- FROM borrowers >- WHERE borrowernumber IN >- (SELECT borrowernumber FROM user_permissions WHERE code = 'catalogue'); >- >--- Bug 14391: Add granular permissions to the administration module >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14391
:
77461
|
77538
|
78109
|
79556
|
79557
|
79558
|
80004
|
80005
|
80006
|
80541
|
80542
|
80543
|
80547
|
81362
|
81451
| 81452 |
82022