X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2-auth%2Fright_time_recording.sql;h=b8e0b939d648c223d1536bbcb497a8c0d96cfbb0;hb=577042c61c5e1fffb8747079b4f9826e51532ee8;hp=dbd0f3251c6ef38cd5df81f8d94262ba3288d7ec;hpb=c87080d8d84989ee40c6ae64151bdf23b629afc1;p=kivitendo-erp.git 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';