X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/c87080d8d84989ee40c6ae64151bdf23b629afc1..66a573e0502ff18373919229fb70a8816402eef4:/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 dbd0f3251..b8e0b939d 100644 --- 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';