QuestionQ101

VerifiedMaintain a data analytics solution

You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. Workspace1 contains a warehouse named DW1.

You share DW1 with User1 and assign User1 the default permissions for DW1.

What can User1 do?

Explanation

When a warehouse is shared with no additional permissions selected, the recipient receives only the default Read permission, which is equivalent to CONNECT in SQL Server and lets them connect to the SQL analytics endpoint — it does not let them query tables/views, build reports on the default semantic model, or read the underlying OneLake files, since those require the ReadData, Build, or ReadAll permissions to be explicitly granted.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!