Created attachment 1226063 [details]
Error from WebUI

Description of problem:
When assigning 6 roles or more to a user who is not admin, it will throw an error when he logs on:
Oops, we're sorry but something went wrong 


Version-Release number of selected component (if applicable):
Satellite 6.2.X


Steps to Reproduce:
1. Create a user
2. Add 6 random roles, do not make him admin
3. Log on as the new user, an error will occur. 


Actual results:
Oops, we're sorry but something went wrong PG::Error: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...ocation')) ORDER BY filters.role_id, filters.id, "roles"."n... ^ : SELECT DISTINCT "filters".* FROM "filters" INNER JOIN "filterings" ON "filterings"."filter_id" = "filters"."id" INNER JOIN "permissions" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "roles" ON "filters"."role_id" = "roles"."id" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" LEFT JOIN taxable_taxonomies ON (filters.id = taxable_taxonomies.taxable_id AND taxable_type = 'Filter') LEFT JOIN taxonomies ON (taxonomies.id = taxable_taxonomies.taxonomy_id) WHERE "roles"."builtin" = 0 AND "roles"."id" IN (7, 6, 8, 18, 17, 2) AND "cached_user_roles"."user_id" = $1 AND (permissions.resource_type = 'Role') AND (permissions.name = 'view_roles') AND (taxable_taxonomies.id IS NULL OR (taxonomies.type = 'Organization') OR (taxonomies.type = 'Location')) ORDER BY filters.role_id, filters.id, "roles"."name" ASC


Expected results:
No error when user log on


Additional info:
As a workaround, a specific role could be create to avoid adding so many roles.