Fix studio for users with derived roles and some other related changes [BB-7834] #18924

Job	Run time
python-3.8,django-pinned,lms-1	12m 14s
python-3.8,django-pinned,lms-2	8m 57s
python-3.8,django-pinned,lms-3	16m 52s
python-3.8,django-pinned,lms-4	21m 2s
python-3.8,django-pinned,lms-5	10m 47s
python-3.8,django-pinned,lms-6	14m 58s
python-3.8,django-pinned,openedx-1	13m 47s
python-3.8,django-pinned,openedx-2	14m 36s
python-3.8,django-pinned,openedx-3	8m 9s
python-3.8,django-pinned,openedx-4	5m 9s
python-3.8,django-pinned,cms-1	3m 18s
python-3.8,django-pinned,cms-2	16m 24s
python-3.8,django-pinned,common-1	9m 37s
python-3.8,django-pinned,common-2	4m 40s
python-3.8,django-pinned,xmodule-1	5m 52s
python-3.8,django-4.2,lms-1	11m 50s
python-3.8,django-4.2,lms-2	8m 36s
python-3.8,django-4.2,lms-3	16m 59s
python-3.8,django-4.2,lms-4	21m 8s
python-3.8,django-4.2,lms-5	11m 12s
python-3.8,django-4.2,lms-6	15m 55s
python-3.8,django-4.2,openedx-1	14m 0s
python-3.8,django-4.2,openedx-2	15m 26s
python-3.8,django-4.2,openedx-3	8m 50s
python-3.8,django-4.2,openedx-4	5m 3s
python-3.8,django-4.2,cms-1	3m 30s
python-3.8,django-4.2,cms-2	16m 54s
python-3.8,django-4.2,common-1	9m 52s
python-3.8,django-4.2,common-2	4m 54s
python-3.8,django-4.2,xmodule-1	5m 56s
coverage (3.8)	2m 38s
compile-warnings-report	11s
Unit tests successful	2s
	5h 39m 18s

Provide feedback