Revision dc35782e
Von Bernd Bleßmann vor 7 Monaten hinzugefügt
| sql/Pg-upgrade2-auth/rights_order_reports_amounts.sql | ||
|---|---|---|
|
SELECT DISTINCT(id), 'sales_order_reports_amounts', TRUE
|
||
|
FROM auth.group
|
||
|
LEFT JOIN auth.group_rights ON (auth.group.id = auth.group_rights.group_id)
|
||
|
WHERE "right" LIKE 'sales_order_edit' OR "right" LIKE 'sales_order_view';
|
||
|
WHERE ("right" LIKE 'sales_order_edit' AND granted = TRUE)
|
||
|
OR ("right" LIKE 'sales_order_view' AND granted = TRUE);
|
||
|
|
||
|
INSERT INTO auth.group_rights (group_id, "right", granted)
|
||
|
SELECT DISTINCT(id), 'purchase_order_reports_amounts', TRUE
|
||
|
FROM auth.group
|
||
|
LEFT JOIN auth.group_rights ON (auth.group.id = auth.group_rights.group_id)
|
||
|
WHERE "right" LIKE 'purchase_order_edit' OR "right" LIKE 'purchase_order_view';
|
||
|
WHERE ("right" LIKE 'purchase_order_edit' AND granted = TRUE)
|
||
|
OR ("right" LIKE 'purchase_order_view' AND granted = TRUE);
|
||
Auch abrufbar als: Unified diff
Rechte: Sehen der Beträge in Auftrags-Berichten: Fix Setzen des Default-Werts