title: Share PowerApp connected to Azure SQL Database without sharing credentials
body: <p>We have an Azure SQL DB and are currently using MSAccess as a user interface. I am investigating using PowerApps instead for better portability and have created a test PowerApp connected to an Azure SQL Database.</p>
  
  <p>When I share the App the other users are not being asked to provide credentials and instead are connecting using my security rights (my SQL Server connector).</p>
  
  <p>I added the PowerApps connector to SQL SERVER - Connect Directly (cloud services), enter our server mytestserver.database.windows.net, 1433, database name, user name and password.</p>
  
  <p>Built a quick form then shared it with another user who does not have any rights to access the Azure SQL Database. </p>
  
  <p>Is it possible to force a user to login and if so how do I implement it?</p>
  
  <p><strong>EDIT</strong> As of 2019-08-01 Microsoft has announce that Azure AD-based authentication for SQL Server databases is planned for PowerApps and Microsoft Flow. Public preview: October 2019, General availability December 2019.</p>
  
  <p>Following is a link to the post.</p>
  
  <p><a href="https://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/cdm-data-integration/better-enterprise-connectivity-sql-server" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/cdm-data-integration/better-enterprise-connectivity-sql-server</a></p>