sql/Pg-upgrade2-auth/rights_for_viewing_project_specific_invoices.sql

   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';