| 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; |