Modern pass-through authentication [migrated]

In a Microsoft environment one can set up a web application that will pass the credentials directly to SQL Server so that permissions are set closest to the data. How can this be achieved in modern applications using SAML and OpenID?