-- Screen / module / action permissions per role code (NAFITHTCS schema). -- NOT executed by the application (the QA connection is read-only for DDL): a DBA runs this once. -- Until it exists the API uses the same data from NTP.Application/Access/PermissionDefaults.cs. -- SU is never stored: it is always allowed everything. A resource that has no row for a role is hidden -- from that role (allow-list). Source of the seed: authorities.xlsx. CREATE TABLE GRAINS_SCREEN_PERMISSIONS ( ROLECODE VARCHAR2(20) NOT NULL, RESOURCE_KEY VARCHAR2(100) NOT NULL, CREATEDATE DATE DEFAULT SYSDATE, CONSTRAINT PK_GRAINS_SCREEN_PERMISSIONS PRIMARY KEY (ROLECODE, RESOURCE_KEY) ); COMMENT ON TABLE GRAINS_SCREEN_PERMISSIONS IS 'Role code -> allowed front-end resource (menu key or action key)'; -- helper: one INSERT per (resource, role) INSERT ALL -- ارسالية عطاء التموين INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.list') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GGO', 'grains.permits.list') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.permits.list') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GPO', 'grains.permits.list') -- شاشة القاطرات INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.registry.trucks') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.registry.trucks') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GPO', 'grains.registry.trucks') -- شاشة المقطورات INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.registry.trailers') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.registry.trailers') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GPO', 'grains.registry.trailers') -- شاشة السائقين المسجلين INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.registry.drivers') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.registry.drivers') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GPO', 'grains.registry.drivers') -- الطلبيات INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.orders.list') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.orders.list') -- طلبية جديدة (action of the orders screen) INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.orders.create') -- شاشة القبان INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.weighbridge') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GGO', 'grains.permits.weighbridge') -- اغلاق إرسالية INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.close') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GGO', 'grains.permits.close') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.permits.close') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GPO', 'grains.permits.close') -- طلبية لسيارة INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.truckOrder') -- شاشة الأيقاف والإنتظار (legacy blackListGrid.cfm) INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.registry.blacklist') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.registry.blacklist') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GPO', 'grains.registry.blacklist') -- طلبية التموين (legacy distributedOrder.cfm) INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.distribution') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.permits.distribution') -- استعلام عن حالة التوزيع لسيارة INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.truckStatus') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.permits.truckStatus') -- شاشة تفعيل الطلبية INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.activation') -- شاشة الادخال اليدوي INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.manualEntry') -- إيقاف\تفعيل الاستنكاف INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.absence') -- الاتصال الصوتي INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.permits.voiceCall') -- طلبية التموين (orders menu) INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.orders.supply') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.orders.supply') -- تثبيت أوزان التحميل INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.orders.weights') -- تقارير حركات قبان التحميل والتفريغ INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.reports.t.weighbridge-events') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.reports.t.weighbridge-events') -- تقرير دور الشركات INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.reports.t.companies-turn') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.reports.t.companies-turn') -- تقرير دور الأفراد INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.reports.t.owners-turn') -- تقرير أوزان التحميل INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.reports.t.loading-weights') -- الارساليات المكتملة INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.reports.t.closed-permits') -- ارسالية عطاء التموين / ملخص التوزيع INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.reports.t.tender-order') INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GTO', 'grains.reports.t.distribution-summary') -- وجهات الشركات INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.orders.companyDest') -- تحديد وجهة ارسالية تموين INTO GRAINS_SCREEN_PERMISSIONS (ROLECODE, RESOURCE_KEY) VALUES ('GOO', 'grains.permits.destinations') SELECT 1 FROM DUAL; COMMIT; -- --------------------------------------------------------------------------------------------------------------------------- -- Registering (adding) and EDITING a truck / trailer / driver is granted ONLY by rows in this table (SU always can). Nothing is granted by -- default and there is no exception for any company. The rights are in db/registry-create-permissions.sql (safe to re-run): -- add: GTO drivers | GOO trucks, trailers | GPO trucks, trailers, drivers; edit trucks and trailers: all roles