Workspace roles (Viewer, Contributor, Member, Admin) and Build permission

Verdict: Consumers who must be filtered by RLS get Viewer; any higher role bypasses it. Member is the least privilege to publish an app. Build permission, separate from workspace roles, unlocks authoring new reports on a shared semantic model.

CriterionViewerContributorMemberAdmin
RLS enforced on the userYes: RLS filters their dataNo: edit rights bypass RLSNo: bypasses RLSNo: bypasses RLS
Publish a new appNoNo: update only, and only when delegatedYes: least privilege to publishYes
Edit content and the semantic modelNo: read and interact onlyYesYesYes
Manage app permissionsNoNoYesYes

Rules

Traps