Revision 7687c447
Von Tamino Steinert vor fast 2 Jahren hinzugefügt
sql/Pg-upgrade2-auth/rights_for_reclamation.sql | ||
---|---|---|
1 |
-- @tag: rights_for_reclamation |
|
2 |
-- @description: Add rights for reclamation |
|
3 |
-- @depends: release_3_5_7 |
|
4 |
-- @locales: Create and edit sales reclamation |
|
5 |
-- @locales: Create and edit purchase reclamation |
|
6 |
|
|
7 |
INSERT INTO auth.master_rights (position, name, description, category) |
|
8 |
VALUES (1150, 'sales_reclamation_edit', 'Create and edit sales reclamation', false); |
|
9 |
|
|
10 |
INSERT INTO auth.group_rights (group_id, "right", granted) |
|
11 |
SELECT id, 'sales_reclamation_edit', true |
|
12 |
FROM auth.group |
|
13 |
WHERE name = 'Vollzugriff'; |
|
14 |
|
|
15 |
INSERT INTO auth.master_rights (position, name, description, category) |
|
16 |
VALUES (2450, 'purchase_reclamation_edit', 'Create and edit purchase reclamation', false); |
|
17 |
|
|
18 |
INSERT INTO auth.group_rights (group_id, "right", granted) |
|
19 |
SELECT id, 'purchase_reclamation_edit', true |
|
20 |
FROM auth.group |
|
21 |
WHERE name = 'Vollzugriff'; |
|
22 |
|
Auch abrufbar als: Unified diff
Reclamation: add master_rights