18 lines
1.0 KiB
SQL
18 lines
1.0 KiB
SQL
-- 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;
|