tjmateus opened a new issue #9404: Add SQL Server support for impersonation URL: https://github.com/apache/incubator-superset/issues/9404 By default, the impersonation on Superset for SQL Server connections is done by replacing the user of the connection string by the logged in user name. This was not the behaviour we were expecting at DefinedCrowd. We want to have an application user capable of impersonating the logged in user. The solution I'm proposing is to use the mssql+pymssql SQLAlchemy adapter you already support and use the `conn_properties` query parameter, which allows us to send SQL queries to the server upon the connection establishment. This query would be `EXECUTE AS USER = '<USER_TO_IMPERSONATE>'`, which will run all the following queries as the logged in user. I already have an implemented solution, I just need your approval to start working on a PR.
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
