NTP_V2/db/grains-screen-permissions.sql

100 lines
7.3 KiB
SQL

-- 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