SqlLab preview permissions error

[mporracindie]

Permissions error on sql lab preview even tho the user has schema access.

How to reproduce the bug

1. Create a rol X with schema access on Y
2. Give a user the following roles: X, Gamma and SqlLab
3. The user can now query the schema but the preview fails with:

You need access to the following tables: `%60___%60.%60___%60`,
            `all_database_access` or `all_datasource_access` permission

Screenshots

Environment

(please complete the following information):

• browser type and version: Chrome Version 102.0.5005.115 (Official Build) (arm64)
• superset version: 1.4.1
• python version: 3.8.12
• any feature flags active: No

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

[rusackas]

Since we're now on 3.1, on the verge of 4.0, we're not supporting 2.x or prior versions actively. If anyone is experiencing this issue in current versions, please file a new issue with updated context and repro steps. Thank you for understanding :)