You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/03/27 10:56:33 UTC
[GitHub] [incubator-superset] tjmateus opened a new issue #9404: Add SQL
Server support for impersonation
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] commented on issue #9404: Add SQL Server support for impersonation
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9404:
URL: https://github.com/apache/incubator-superset/issues/9404#issuecomment-635742032
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] stale[bot] closed issue #9404: Add SQL Server support for impersonation
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #9404:
URL: https://github.com/apache/incubator-superset/issues/9404
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org