Проектирование информационной системы малого предприятия
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
iggers for tables ***/
****************************************************************************/
/* Trigger: CONTRAGENT_BI */TRIGGER CONTRAGENT_BI FOR CONTRAGENTBEFORE INSERT POSITION 0
if (new.id is null) then
new.id = gen_id(g_contragent,1);
^
/* Trigger: MATERIALS_BI */TRIGGER MATERIALS_BI FOR MATERIALSBEFORE INSERT POSITION 0
if (new.id is null) then
new.id = gen_id(g_materials,1);
^
/* Trigger: MEASURE_BI */TRIGGER MEASURE_BI FOR MEASUREBEFORE INSERT POSITION 0
if (new.id is null) then
new.id = gen_id(g_measure,1);
^
/* Trigger: OKNO_BI */TRIGGER OKNO_BI FOR OKNOBEFORE INSERT POSITION 0
if (new.id is null) then
new.id = gen_id(g_okno,1);
^
/* Trigger: PARTY_BI */TRIGGER PARTY_BI FOR PARTYBEFORE INSERT POSITION 0
if (new.id is null) then
new.id = gen_id(g_party,1);
^
/* Trigger: POSTAVKA_BI */TRIGGER POSTAVKA_BI FOR POSTAVKABEFORE INSERT POSITION 0
if (new.id is null) then
new.id = gen_id(g_postavka,1);
^
/* Trigger: PRICE_LIST_BI */TRIGGER PRICE_LIST_BI FOR PRICE_LISTBEFORE INSERT POSITION 0
IF (NEW.ID IS NULL) THEN
NEW.ID = GEN_ID(G_PRICE_LIST,1);
^
/* Trigger: RASHOD_MT_BI */TRIGGER RASHOD_MT_BI FOR RASHOD_MTBEFORE INSERT POSITION 0
if (new.id is null) then
new.id = gen_id(g_rashod_mt,1);
^
/* Trigger: WORK_BI */TRIGGER WORK_BI FOR WORK_LISTBEFORE INSERT POSITION 0
IF (NEW.ID IS NULL) THEN
NEW.ID = GEN_ID(G_WORK,1);
^
/* Trigger: ZAKAZ_BI */TRIGGER ZAKAZ_BI FOR ZAKAZBEFORE INSERT POSITION 0
if (new.id is null) then
new.id = gen_id(g_zakaz,1);
end
^
TERM ; ^
Приложение Б
Описание прав пользователей
grant insert on contractor to insert_into_contractor^insert on person to insert_into_contractor^update on contractor to update_contractor^update on person to update_contractor^
select on consignment to DeliveryAcceptAll^select on delivery to DeliveryAcceptAll^update on delivery to DeliveryAcceptAll^
role pr_suppl^
all on delivery to pr_suppl^all on consignment to pr_suppl^
all on contractor to pr_suppl^all on person to pr_suppl^all on contractor_group to pr_suppl^
select on dublicate to pr_suppl^select on dublicate_jobs to pr_suppl^
select on form to pr_suppl^select on form_group to pr_suppl^
all on material_group to pr_suppl^all on material to pr_suppl^all on measurement_unit to pr_suppl^
select on material_consumption to pr_suppl^select on price_list to pr_suppl^select on production_order to pr_suppl^
execute on procedure DeliveryAcceptAll to pr_suppl^execute on procedure insert_into_contractor to pr_suppl^execute on procedure update_contractor to pr_suppl^
role pr_tech^
select on delivery to pr_tech^select on consignment to pr_tech^
select on contractor to pr_tech^select on contractor_group to pr_tech^select on person to pr_tech^
all on dublicate to pr_tech^all on dublicate_jobs to pr_tech^
all on form to pr_tech^all on form_group to pr_tech^
select on material_group to pr_tech^select on material to pr_tech^select on measurement_unit to pr_tech^all on material_consumption to pr_tech^select on price_list to pr_tech^select on production_order to pr_tech^
role pr_order^
select on delivery to pr_order^select on consignment to pr_order^
all on contractor to pr_order^all on person to pr_order^all on contractor_group to pr_order^
all on dublicate to pr_order^all on dublicate_jobs to pr_order^
select on form to pr_order^select on form_group to pr_order^
select on material_group to pr_order^select on material to pr_order^select on measurement_unit to pr_order^select on material_consumption to pr_order^select on price_list to pr_order^all on production_order to pr_order^execute on procedure insert_into_contractor to pr_order^execute on procedure update_contractor to pr_order^
role pr_dir^
select on delivery to pr_dir^select on consignment to pr_dir^
select on contractor to pr_dir^select on contractor_group to pr_dir^select on person to pr_dir^
select on dublicate to pr_dir^select on dublicate_jobs to pr_dir^
select on form to pr_dir^select on form_group to pr_dir^
select on material_group to pr_dir^select on material to pr_dir^select on measurement_unit to pr_dir^
select on material_consumption to pr_dir^all on price_list to pr_dir^select on production_order to pr_dir^
pr_suppl to pu_suppl^pr_tech to pu_tech^pr_order to pu_order^pr_dir to pu_dir^
Copyright © 2008-2014 studsell.com рубрикатор по предметам рубрикатор по типам работ пользовательское соглашение