If you don't have access to the root collection but inner collections, you get permission errors in QuestionPicker

[ranquild]

Describe the bug

If you have mixed collection access you won't be able to select a collection if you don't have access to all parent collections.

To Reproduce

1. Create several subcollections in Our analytics, like A -> B -> C
2. Go to Admin -> Permissions and revoke access from Our analytics collection; grant access to B
3. Log in as a regular user
4. Try selecting any descendant collection of Our analytics in the product now and see permission errors (QuestionPicker)

Note - the collection sidebar on the left handles this case correctly.

Expected behavior

I should be able to select collections that I have access to without permission errors.

Logs

No relevant logs

Information about your Metabase installation

v50

Severity

P1

Additional context

No response