
-- Give user defined user roles access to viewAuthorization employee list
INSERT INTO ohrm_user_role_screen (user_role_id, screen_id, can_read, can_create, can_update, can_delete)
SELECT r.id, s.id, 1, 0, 0, 0 FROM ohrm_screen s, ohrm_user_role r WHERE 
    s.action_url in ('viewAuthorizationEmployeeList')
    AND r.`is_predefined` = 0;