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
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.