Revision 9813dbb1
Von Bernd Bleßmann vor 2 Monaten hinzugefügt
| sql/Pg-upgrade2-auth/rights_order_reports_amounts.sql | ||
|---|---|---|
| 20 | 20 |
SELECT DISTINCT(id), 'sales_order_reports_amounts', TRUE |
| 21 | 21 |
FROM auth.group |
| 22 | 22 |
LEFT JOIN auth.group_rights ON (auth.group.id = auth.group_rights.group_id) |
| 23 |
WHERE "right" LIKE 'sales_order_edit' OR "right" LIKE 'sales_order_view'; |
|
| 23 |
WHERE ("right" LIKE 'sales_order_edit' AND granted = TRUE)
|
|
| 24 |
OR ("right" LIKE 'sales_order_view' AND granted = TRUE);
|
|
| 24 | 25 |
|
| 25 | 26 |
INSERT INTO auth.group_rights (group_id, "right", granted) |
| 26 | 27 |
SELECT DISTINCT(id), 'purchase_order_reports_amounts', TRUE |
| 27 | 28 |
FROM auth.group |
| 28 | 29 |
LEFT JOIN auth.group_rights ON (auth.group.id = auth.group_rights.group_id) |
| 29 |
WHERE "right" LIKE 'purchase_order_edit' OR "right" LIKE 'purchase_order_view'; |
|
| 30 |
WHERE ("right" LIKE 'purchase_order_edit' AND granted = TRUE)
|
|
| 31 |
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