apache / apache/superset

Permission denied for sql access between databases

Open
#31,406 16 comments 0 reactions 1 assignee Claimed by @betodealmeida View on GitHub
data:databases requires:more-info sqllab validation:required
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.

![image](https://github.com/user-attachments/assets/e23f89f7-2e25-41ff-b030-5badeb6c0a47)

```
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:

![image](https://github.com/user-attachments/assets/41bafd0a-1208-4bc1-b15f-231c1f89c818)

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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.