Up next in 10
Grant Workspace Permission to Users to Access & Write DQL Command In Fabric Warehouse
May 1, 2024
In this video, I demonstrated how to grant workspace permission to users to access and write DQL command in Fabric Warehouse.
Show More Show Less View Video Transcript
0:00
Hello everyone. In this Microsoft Fabric video, I'm going to show you how to grant permission
0:08
to a user within your tenant to have access to a table within your data warehouse in order
0:15
to perform data query language like using the select. So let's get started. Now I created
0:23
two accounts, the super account which belongs to myself. This is abuela.excel.getconsult
0:30
111.onmicrosoft.com. And then in the Google Chrome, I have another account, Enoch, within
0:36
the same tenant. Now when I check the for instance, the private experience, and I come
0:43
to the workspaces, you can see this person do not have any workspace. Therefore, the
0:49
person is unable to access any data. Now I'm going to come back to the edge. And what
0:56
I've done here is to create a workspace called HR database. And within the workspace, we
1:02
have our data warehouse, the data sets and the warehouse. When I click on this employee
1:09
details, I can see the table. And of course, we can begin to write query against the data
1:16
sets. Now, we want to give access to Enoch to be able to work with the table and write
1:24
select statements. To do that, we're going to come back to the workspace level. And then
1:31
you're going to see this manage access. And then you're going to see manage access. And
1:37
of course, you can see the name of the workspace. Now you can click on this add people or group
1:43
And then in the enter name or email, I'm going to search for the person can use that email or
1:48
their name. So I'm going to grab the person's details. And then I can specify whether they're
1:54
going to be viewer, contributor, member or admin. So by default, viewer is fine, click on
2:01
add. Of course, you can see it is successfully added. Now let's switch back to the Google
2:07
Chrome and then refresh the page. Now we should be able to see the HR underscore database
2:15
workspace. And of course, they're going to have access to the table. So let's come to
2:21
workspaces. And there you go, we have the HR database. So they are able to access the
2:28
workspace. So let's click on that. And then we can see the employee details. So click on
2:34
that and that's going to open the SQL endpoint where we can write the query. So we can see
2:40
the table, click on new SQL query. Now this is fine, just click on OK. And then we can
2:46
easily perform select star from and then grab the table and then click on execute. And that's
2:58
it. We can even use the where clause, let's say where salary is greater than or equal to 65,000
3:11
Click on run. And that works pretty fine. So that's basically how we can grant permission to a user
3:18
to have access to a table in our data warehouse. Let's want to get rid of the access, you have to
3:27
come back to the super account. And then you're going to come to this manage access again. And of
3:33
course, you can see Enoch right here, just click on that and click on remove. And that takes the
3:39
permission or the privileges. And then let's go back to Chrome, click on refresh. And go ahead
3:48
with this reload. When I click on workspaces, we can see the HR underscore database workspace is
3:55
gone because we have revoked the permission. So this basically how we can grant and revoke permissions
4:05
to users within workspace level. Thank you and bye for now. Cheers