[GitHub] mmuru opened a new issue #4969: The same schemas are getting added for the same database user with different databases

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org