I'm building an internal application for a corporation, using Flask-LDAP for authentication. In this way the firm can manage permissions without having to worry about a separate admin interface.
The firm has a sophisticated DBA staff with many MSSQL servers, and DB permissions are heavily managed on a per user/group basis. As such, I'd like to respect those permissions and not write the application with a super account. Is it possible to pass the LDAP ticket through to PyODBC? For many userland applications, we can simple set the connection on PyODBC to trusted, which makes things very clean. However I'm not sure how to do this for a web session.
Any help would be greatly appreciated.