Скачать или смотреть PowerApps - SQL to Azure AD Authentication

How to switch from SQL authentication to Azure AD authentication in PowerApps.

It's never been easier to get started with SQL Server and Azure AD. In this blog post, we'll go over how you can set up a secure PowerApp that connects to your Azure SQL database using Azure AD authentication.

Script used in video:
-- add contained Azure AD user
CREATE USER "Adventure Works Users" FROM EXTERNAL PROVIDER WITH DEFAULT_SCHEMA = dbo;
-- add user to role(s) in db
ALTER ROLE db_datareader ADD MEMBER "Adventure Works Users";
ALTER ROLE db_datawriter ADD MEMBER "Adventure Works Users";

--Then we'll verify the correct access.
SELECT DP1.name AS DatabaseRoleName,
isnull (DP2.name, 'No members') AS DatabaseUserName
FROM sys.database_role_members AS DRM
RIGHT OUTER JOIN sys.database_principals AS DP1
ON DRM.role_principal_id = DP1.principal_id
LEFT OUTER JOIN sys.database_principals AS DP2
ON DRM.member_principal_id = DP2.principal_id
WHERE DP1.is_fixed_role = 1
ORDER BY DP2.name;