CRM/Upgrade/Incremental/sql/4.2.7.mysql.tpl

   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;