Permission denied for sql access between databases
- Dominant language
- Python
- Stars
- 74.8k
- Forks
- 18.3k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 692
Description
I have another inquiry also regarding this. Previously `4.0.1` when I select for example `select * from database_name.schema_name.table_name` it was working fine.
I applied the fix but still cannot select with database_name access denied. I required to grant full access `id:` to do that which wasnt before.

```
Dec 8 11:26:10 ef-extsuperset superset[3696623]: 2024-12-08 11:26:10,802:DEBUG:superset.sql_parse:Parsing with sqlparse statement: select * from abcm.dbo.temp ;
Dec 8 11:26:10 ef-extsuperset superset[3696623]: 2024-12-08 11:26:10,816:DEBUG:superset.stats_logger:#033[36m[stats_logger] (incr) SqlLabRestApi.execute_sql_query.error#033[0m
Dec 8 11:26:10 ef-extsuperset superset[3696623]: 2024-12-08 11:26:10,816:DEBUG:superset.stats_logger:#033[36m[stats_logger] (timing) SqlLabRestApi.execute_sql_query.time | 122.99154791980982 #033[0m
Dec 8 11:26:11 ef-extsuperset superset[3696616]: 2024-12-08 11:26:11,842:DEBUG:superset.stats_logger:#033[36m[stats_logger] (incr) log#033[0m
```
but I am able to select with dbo only:

This needed for databases I have in the same instance and calling each other.
_Originally posted by @Habeeb556 in https://github.com/apache/superset/issues/31183#issuecomment-2525557400_
Contributor guide
Assessment
This issue has not been assessed yet.