mmuru opened a new issue #4969: The same schemas are getting added for the same database user with different databases URL: https://github.com/apache/incubator-superset/issues/4969 Make sure these boxes are checked before submitting your issue - thank you! - [ ] I have checked the superset logs for python stacktraces and included it here as text if any - [ ] 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 ### Superset version 0.24.0 ### Expected results The same schemas should not show up in the Sqllab schema drop down list. ### Actual results It shows non-exists schemas for the database/datasource. ### Steps to reproduce 1) Add database (Sources->Databases) with a database user and database such as test1 2) Add another database with the same database user but with different database such as test2 3) Go to SqlLab -> SQL Editor -> Select database as test1 -> schemas -> list of schemas for test1 database (as expected) 4) Go to SqlLab -> SQL Editor -> Select database as test2-> schemas -> list of schemas for test1 database (expected to see test2 related schemas) Please note, on the database side, the user has two different roles and able to access them from SQL clients. For a workaround, I had to create two separate database users and added to superset.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on 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]
