Merge branch 'b-3.6.1' of ../kivitendo-erp_20220811

[kivitendo-erp.git] / sql / Pg-upgrade2-auth / right_time_recording.sql

diff --git a/sql/Pg-upgrade2-auth/right_time_recording.sql b/sql/Pg-upgrade2-auth/right_time_recording.sql
index dbd0f3251c6ef38cd5df81f8d94262ba3288d7ec..b8e0b939d648c223d1536bbcb497a8c0d96cfbb0 100644 (file)
--- a/sql/Pg-upgrade2-auth/right_time_recording.sql
+++ b/sql/Pg-upgrade2-auth/right_time_recording.sql
@@ -4,7 +4,12 @@
 -- @locales: Create, edit and list time recordings
 
 INSERT INTO auth.master_rights (position, name, description, category)
-  VALUES ((SELECT position + 10 FROM auth.master_rights WHERE name = 'productivity'),
+  VALUES ((SELECT position + 50 FROM auth.master_rights WHERE name = 'email_employee_readall'),
           'time_recording',
           'Create, edit and list time recordings',
           FALSE);
+
+INSERT INTO auth.group_rights (group_id, "right", granted)
+  SELECT id, 'time_recording', true
+  FROM auth.group
+  WHERE name = 'Vollzugriff';