dosubot[bot] commented on issue #30978: URL: https://github.com/apache/superset/issues/30978#issuecomment-2486384064
<!-- Greeting --> Hello @antonio-tg 👋! I'm here to help you with any bugs, questions, or contributions you may have regarding Superset. Let's work together to resolve this issue! <!-- Answer --> In Superset 4.0.2, there was a change that added the ability to disallow SQL functions per engine, which might be affecting the Gamma role's ability to execute certain SQL functions like `MAX`, `SUM`, `LPAD`, and others <sup>[[1]](https://github.com/apache/superset/blob/master/CHANGELOG/4.0.2.md)</sup>. This change could be the reason why your Gamma users are experiencing issues with executing queries that include these functions. To address this, you may need to adjust the SQL function execution permissions for the Gamma role. Unfortunately, I don't have specific instructions on how to configure these permissions directly. However, you might want to look into the Superset configuration settings related to SQL function execution permissions per engine, as this is where the change was introduced. If you have access to the Superset configuration files, you could check for any settings related to SQL function permissions and adjust them accordingly. Alternatively, you might consider creating a custom role with the necessary permissions if modifying the existing Gamma role does not resolve the issue. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- 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]
