@@ -, +, @@ delete_report --------- 1) Back up db 2) drop database koha_library; 3) create database koha_library; 4) web install with all sample data with system user 6) log into staff client as system user 7) make sample koha admin user a superlibrarian 8) set username and password for sample koha admin user 9) log out and log in as koha admin create_reports and execute_reports. create_reports, but not execute_reports. execute_reports, but not create_reports. -- should have delete_reports -- should have delete_reports -- should NOT have delete_reports -- should NOT have delete_reports --- installer/data/mysql/atomicupdate/bug_16978.sql | 6 ++++++ 1 file changed, 6 insertions(+) --- a/installer/data/mysql/atomicupdate/bug_16978.sql +++ a/installer/data/mysql/atomicupdate/bug_16978.sql @@ -1,3 +1,9 @@ INSERT IGNORE INTO `permissions` (module_bit, code, description) VALUES (16, 'delete_reports', 'Delete SQL reports'); + +INSERT IGNORE INTO user_permissions + (borrowernumber, module_bit,code) + SELECT borrowernumber,module_bit,'delete_reports' + FROM user_permissions + WHERE module_bit=16 AND code='create_reports'; --