Azure AD for authentication with Data Warehouse

Hi everyone,

I’m trying to set up an authentication using Azure AD to login to DWH.

Let’s say i have an directory called target.onmicrosoft.com

I have 2 external user who was already invited to this directory ([user1@gmail.com](mailto:user1@gmail.com), [user2@gmail.com](mailto:user2@gmail.com))

For user1, i gave him Owner permission on subscription scope.

For user2, i only gave Reader permission on subscription scope

From DWH AD admin, i set user1 as admin.

Now i can login to DWH using user1’s credential without creating anything.

But for user2, how can i do that? I don’t want to give user2 admin permission. In other words, i just want to give him permission on a specific schema in DWH.

submitted by /u/khoigeneral
[link] [comments]

Leave a Reply