QuestionQ78

VerifiedMaintain a data analytics solution

You have a Fabric workspace named Workspace1 that includes these items:

  • A warehouse named Warehouse1
  • A semantic model named Model1
  • An interactive report named Report1

You need to grant a user named User1 access to one table in Warehouse1. The solution must adhere to the principle of least privilege.

What should you do first?

Explanation

Fabric Warehouse uses object-level T-SQL permissions such as GRANT to restrict access to a specific table. For granular access, define the SQL permission first; then grant the user the minimum item-level Read permission needed to connect. The db_datareader-equivalent permission allows reading all tables and views, so it does not meet least privilege.

Learn more

Community Discussion

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