elukey opened a new issue #9543: Unknown error returned when a Alpha user tries to use Sqllab URL: https://github.com/apache/incubator-superset/issues/9543 Hi! I have recently tried to debug why users where not able to use Presto (configured as database via sql alchemy) in Sqllab. They reported an "Unknown error" reported as big red box when accessing the Sqllab. I discovered later on that this was due to the absence of the sqllab role, but I think that the error message should be more clear (like "you don't have permissions to do this etc..". Also, I see that Alpha has a lot of permissions for the Sqllab (listed in the role definition), but the most important ones are missing to allow users to query data. I get why one would want to selectively allow access to sqllab and not grant it by default, but wouldn't it be better all or nothing? For example, the sqllab role in my Superset allows: can search queries on Superset, can sql json on Superset, can csv on Superset, menu access on SQL Lab, can sqllab on Superset, can sqllab viz on Superset, menu access on SQL Editor, menu access on Query Search, menu access on Saved Queries, can list on UserDBModelView, can list on UserRemoteUserModelView And only the following are not in Alpha: can sql json on Superset menu access on SQL Lab can list on UserDBModelView can list on UserRemoteUserModelView ### Expected results A clear error about permissions, that leads an admin to the proper debugging. ### Actual results A general "Unknown error" is displayed, without any trace of it in the logs (to gather further info). #### Screenshots If applicable, add screenshots to help explain your problem. #### How to reproduce the bug 1. Alpha user goes to the Sqllab 2. Alpha user tries to use any database, getting Unknown Error ### Environment (please complete the following information): - superset version: latest ### Checklist Make sure these boxes are checked before submitting your issue - thank you! - [x] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [x] I have reproduced the issue with at least the latest released version of superset. - [x] I have checked the issue tracker for the same issue and I haven't found one similar. ### Additional context Add any other context about the problem here.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
