-- Grants GTO two more reports: ارسالية عطاء التموين (tender-order) and ملخص التوزيع (distribution-summary). -- Safe to re-run; not run by the app. Take either away by deleting its row (the API applies it within about a minute). INSERT INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) SELECT v.rolecode, v.resource_key FROM (SELECT 'GTO' AS rolecode, 'grains.reports.t.tender-order' AS resource_key FROM dual UNION ALL SELECT 'GTO', 'grains.reports.t.distribution-summary' FROM dual) v WHERE NOT EXISTS (SELECT 1 FROM GRAINS_SCREEN_PERMISSIONS p WHERE p.rolecode = v.rolecode AND p.resource_key = v.resource_key); COMMIT; -- الاتصال الصوتي (voice call button on ارساليات التموين; legacy action 96): GTO. INSERT INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) SELECT 'GTO', 'grains.permits.voiceCall' FROM dual WHERE NOT EXISTS (SELECT 1 FROM GRAINS_SCREEN_PERMISSIONS p WHERE p.rolecode = 'GTO' AND p.resource_key = 'grains.permits.voiceCall'); COMMIT;