dosubot[bot] commented on issue #31406: URL: https://github.com/apache/superset/issues/31406#issuecomment-2536893993
<!-- Answer --> I found a similar closed issue regarding database access in SQL Lab, but no solution was found in the comments <sup>[[1]](https://github.com/apache/superset/issues/13689)</sup>. Regarding your current issue, it seems that after the update to version 4.0.1, you are encountering permission issues when trying to perform cross-database queries. The error message suggests that you need either `all_database_access` or `all_datasource_access` permissions to execute queries like `select * from database_name.schema_name.table_name`. To resolve this, you might need to adjust the permissions for the user attempting the query. Here are some steps you can consider: 1. **Check User Roles and Permissions**: Ensure that the user has the necessary permissions. If cross-database queries are required, you might need to grant `all_database_access` or `all_datasource_access` permissions, although you mentioned this wasn't needed before. 2. **Review Role Changes in Version 4.0.1**: Since you mentioned this issue arose after updating to version 4.0.1, review any changes in the release notes or documentation regarding permissions and roles that might affect database access. 3. **SQL Lab Permissions**: Ensure that the user has the SQL Lab access permissions, as these are required to execute queries in SQL Lab. If these steps do not resolve the issue, you may need to investigate further into any specific changes in your Superset configuration or database settings that could be affecting access. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/65ed4c5f-3c9b-44bc-af0e-207063a3511f?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/65ed4c5f-3c9b-44bc-af0e-207063a3511f?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/65ed4c5f-3c9b-44bc-af0e-207063a3511f?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/65ed4c5f-3c9b-44bc-af0e-207063a3511f?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/65ed4c5f-3c9b-44bc-af0e-207063a3511f?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/65ed4c5f-3c9b-44bc-af0e-207063a3511f?feedback_type=other)</sup> -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
