Project

General

Profile

Download (680 Bytes) Statistics
| Branch: | Tag: | Revision:

kivitendo / sql / Pg-upgrade2-auth / rights_for_viewing_project_specific_invoices.sql @ bc182129

1
-- @tag: rights_for_viewing_project_specific_invoices
2
-- @description: Rechte zum Anzeigen von Rechnungen, die zu Projekten gehören
3
-- @depends: release_3_5_3
4
-- @locales: Projects: edit the list of employees allowed to view invoices
5
INSERT INTO auth.master_rights (position, name, description, category)
6
VALUES (
7
  (SELECT position + 2
8
   FROM auth.master_rights
9
   WHERE name = 'project_edit'),
10
  'project_edit_view_invoices_permission',
11
  'Projects: edit the list of employees allowed to view invoices',
12
  false
13
);
14

    
15
INSERT INTO auth.group_rights (group_id, "right", granted)
16
SELECT id, 'project_edit_view_invoices_permission', true
17
FROM auth.group
18
WHERE name = 'Vollzugriff';