dwene opened a new issue #9225: No database role created when database is created. URL: https://github.com/apache/incubator-superset/issues/9225 A clear and concise description of what the bug is. When a new database is created, there isn't a corresponding database role created. I've been trying to follow the docs for adding Gamma users here: https://superset.incubator.apache.org/security.html#sql-lab I'd like to create a Gamma user, give them sql lab rights, and give them access to a single database. When I add a database in the UI, and try to create a new role with privileges to query that database, there doesn't appear to be one. There is however a database role for the initially `examples` database. So it seems to me like there should be a database role for the other databases I added also. ### Expected results A new database role is created when I add a database ### Actual results No database role is created. #### Screenshots <img width="653" alt="Screen Shot 2020-02-28 at 5 32 00 PM" src="https://user-images.githubusercontent.com/12628251/75594998-636a0f00-5a50-11ea-8afb-ac68aef58150.png";> <img width="649" alt="Screen Shot 2020-02-28 at 5 32 11 PM" src="https://user-images.githubusercontent.com/12628251/75594999-6402a580-5a50-11ea-9a8b-d1996670a62a.png";> Notice how there is no database privilege for "dwene" but there is one for "example" #### How to reproduce the bug 1. Go to Sources -> Databases. 2. Add a new database. 3. Go to roles. 4. Try to create a new role with the new database privilege. 5. Notice that there is no database privilege, only datasource and schema privileges. ### Environment (please complete the following information): - superset version: `0.35.2` - python version: whatever is in the built docker container. ### 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]
![https://user-images.githubusercontent.com/12628251/75594998-636a0f00-5a50-11ea-8afb-ac68aef58150.png"](https://user-images.githubusercontent.com/12628251/75594998-636a0f00-5a50-11ea-8afb-ac68aef58150.png"){kind=link}
![https://user-images.githubusercontent.com/12628251/75594999-6402a580-5a50-11ea-9a8b-d1996670a62a.png"](https://user-images.githubusercontent.com/12628251/75594999-6402a580-5a50-11ea-9a8b-d1996670a62a.png"){kind=link}