No database privilege created when database is created.

[dwene]

When a new database is created, there isn't a corresponding database privilege 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 privilege for the initially examples database. So it seems to me like there should be a database privilege for the other databases I added also, so that I can grant Gamma+sql_lite role users access to use sql lab.

Expected results

A new database privilege is created when I add a database

Actual results

No database privilege is created.

Screenshots

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.

[nytai]

hey @dwene check out: #8699

It may satisfy your requirements

[dwene]

Hey @nytai , thanks for responding.

The row based security is pretty cool! But not really what I'm looking for. I'm looking for a way to grant a user access to SQL lab for only 1 database. It seems like the way to do that is by making a new role with that database privilege (datasource and schema privileges don't appear to be enough), but I can't seem to find a way to add it.

[dwene]

Additional screenshot showing missing database_access privilege.
I've added 2 other databases.

[dwene]

Interestingly enough, editing the database and saving (without making any changes) seems to resolve the problem.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.