-- Screens of the accountant role GNAC (legacy GrainsBilling menu): المطالبات المالية, ادخال المطالبة (same key as the claims -- list), الغرامات, الأجور, فواتير التموين, التأكد من الفواتير (key grains.orders.invoiceCheck). -- Run on a database where GRAINS_SCREEN_PERMISSIONS already exists. Safe to re-run. Not executed by the application. -- Delete a row to take a screen away (the API applies it within about a minute, the browser on the next reload or sign-in). INSERT INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) SELECT v.rolecode, v.resource_key FROM (SELECT 'GNAC' AS rolecode, 'grains.orders.billing' AS resource_key FROM dual UNION ALL SELECT 'GNAC', 'grains.orders.fines' FROM dual UNION ALL SELECT 'GNAC', 'grains.orders.wages' FROM dual UNION ALL SELECT 'GNAC', 'grains.orders.invoices' FROM dual UNION ALL SELECT 'GNAC', 'grains.orders.invoiceCheck' 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; -- Check (expect 5 rows): -- SELECT rolecode, resource_key FROM GRAINS_SCREEN_PERMISSIONS WHERE rolecode = 'GNAC' ORDER BY resource_key;