10 lines
606 B
SQL
10 lines
606 B
SQL
-- Role DISP (company dispatcher): view ارسالية عطاء التموين (grains.permits.list).
|
|
-- The API restricts a DISP user to the permits of his own company (user company code), like a company user.
|
|
-- Run once by a DBA on NAFITHTCS (safe to re-run). Needs db/grains-screen-permissions.sql applied first.
|
|
MERGE INTO GRAINS_SCREEN_PERMISSIONS t
|
|
USING (SELECT 'DISP' AS ROLECODE, 'grains.permits.list' AS RESOURCE_KEY FROM DUAL) s
|
|
ON (t.ROLECODE = s.ROLECODE AND t.RESOURCE_KEY = s.RESOURCE_KEY)
|
|
WHEN NOT MATCHED THEN INSERT (ROLECODE, RESOURCE_KEY) VALUES (s.ROLECODE, s.RESOURCE_KEY);
|
|
|
|
COMMIT;
|