Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-11354 Fix empty permissions for report instances |
2 | UPDATE civicrm_report_instance SET permission = 'access CiviReport' | |
3 | WHERE report_id = 'survey/detail' and permission = ''; | |
4 | ||
5 | UPDATE civicrm_report_instance SET permission = 'access CiviMail' | |
6 | WHERE report_id = 'mailing/detail' and permission = ''; | |
7 | ||
8 | UPDATE civicrm_report_instance SET permission = 'access CiviMember' | |
9 | WHERE report_id = 'member/contributionDetail' and permission = ''; | |
10 | ||
11 | UPDATE civicrm_report_instance SET permission = 'access CiviGrant' | |
12 | WHERE report_id = 'grant/statistics' and permission = ''; | |
13 | ||
14 | UPDATE civicrm_report_instance SET permission = 'access CiviReport' | |
15 | WHERE permission = '0' OR permission = '' OR permission IS NULL; |