From 9c0d1e30a155039c87395f83429a269344449846 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Fri, 11 Oct 2019 12:17:31 +0200 Subject: [PATCH] Recht zum Einsehen von Einkaufsdokumenten aller Mitarbeiter (Trennung VK/EK) MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Das Recht "sales_all_edit" galt bisher sowohl für Verkauf als auch für Einkauf. Nun wird das getrennt. --- locale/de/all | 1 + locale/en/all | 1 + sql/Pg-upgrade2-auth/right_purchase_all_edit.sql | 14 ++++++++++++++ 3 files changed, 16 insertions(+) create mode 100644 sql/Pg-upgrade2-auth/right_purchase_all_edit.sql diff --git a/locale/de/all b/locale/de/all index 30b23d43f..91ffb50fc 100755 --- a/locale/de/all +++ b/locale/de/all @@ -3848,6 +3848,7 @@ $self->{texts} = { 'View background job execution result' => 'Verlauf der Hintergrund-Job-Ausführungen anzeigen', 'View sent email' => 'Verschickte E-Mail anzeigen', 'View warehouse content' => 'Lagerbestand ansehen', + 'View/edit all employees purchase documents' => 'Bearbeiten/ansehen der Einkaufsdokumente aller Mitarbeiter', 'View/edit all employees sales documents' => 'Bearbeiten/ansehen der Verkaufsdokumente aller Mitarbeiter', 'Von Konto: ' => 'von Konto: ', 'WHJournal' => 'Lagerbuchungen', diff --git a/locale/en/all b/locale/en/all index fd987d3c2..b63a581ef 100644 --- a/locale/en/all +++ b/locale/en/all @@ -3847,6 +3847,7 @@ $self->{texts} = { 'View background job execution result' => '', 'View sent email' => '', 'View warehouse content' => '', + 'View/edit all employees purchase documents' => '', 'View/edit all employees sales documents' => '', 'Von Konto: ' => '', 'WHJournal' => 'Warehouse journal', diff --git a/sql/Pg-upgrade2-auth/right_purchase_all_edit.sql b/sql/Pg-upgrade2-auth/right_purchase_all_edit.sql new file mode 100644 index 000000000..ca354421d --- /dev/null +++ b/sql/Pg-upgrade2-auth/right_purchase_all_edit.sql @@ -0,0 +1,14 @@ +-- @tag: right_purchase_all_edit +-- @description: Recht zum Bearbeiten von Einkaufsdokumenten aller Mitarbeiter (Trennung nach VK u. EK) +-- @depends: release_3_5_4 +-- @locales: View/edit all employees purchase documents + +INSERT INTO auth.master_rights (position, name, description, category) + VALUES ((SELECT position + 10 FROM auth.master_rights WHERE name = 'purchase_letter_edit'), + 'purchase_all_edit', + 'View/edit all employees purchase documents', + FALSE); + +-- same rights as sales_all_edit because sales and purchase were not distingushed before +INSERT INTO auth.group_rights (group_id, "right", granted) + SELECT group_id, 'purchase_all_edit', granted FROM auth.group_rights WHERE "right" = 'sales_all_edit'; -- 2.20.1