Can't access database in SQL lab

[liamnv]

A clear and concise description of what the bug is.

I'm create a role to access a database schema, assign this role to a user, but user can query this table in `CREATEA TABLE AS

Expected results

User can run this query

Actual results

Superset return you need access to the following tables: xxx, all_database_access or all_datasource_access

Screenshots

How to reproduce the bug

1. Connect Superset to Trino
2. Add database A & B from Trino to Superset
3. Create Role test, assign permission schema acccess con A.xxx, assign to user X
4. Run query similar to screenshot

Environment

• superset version: 1.0.1
• python version: 3.8

Checklist

Make sure to follow these steps 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.

[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.

[rusackas]

Closing as stale since the issue is over 2 years old, but if you're still facing this, let's revisit it!

[xujipm]

I'm still facing this on version 3.1.3

[rusackas]

@xujipm do you have any more context to add to the issue? It seems like nobody else ran into this issue for over three years.

[xujipm]

@xujipm do you have any more context to add to the issue? It seems like nobody else ran into this issue for over three years.

I have authorized the permissions of sample.main to this user, but this account still cannot be queried in sql_lab