SAP Knowledge Base Article - Public

3415687 - User with DW Viewer role cannot preview data in a view

Symptom

User with DW Viewer role is not able to preview data from view and get he following error message instead :

  • "you are not allowed to view this data"

Request might fail with the following error:

  • 403 Forbidden  {"error":{"message":"FORBIDDEN_NO_PRIVILEGE"}}

Environment

SAP Datasphere

Reproducing the Issue

  1. Logon to Datasphere with DW Viewer Role user
  2. Go to Data Builder --> Select a view --> Choose Preview Data

Cause

DW Viewer role is not allowed to view the data preview on remote tables and views (Which are not exposed for consumption).

Resolution

As explained in SAP Datasphere Help Roles and Privileges by App and Feature:
For data preview on remote tables and non-exposed views, user needs privilege Data Warehouse Consumption.Execute (included in DW Modeler standard role).

An alternative is to create a custom role based on DW Viewer + Data Warehouse Consumption.Execute.
With that scoped roles can be created and assigned users would be able to perform data preview in all objects in Data Builder. 

By default DW Viewer includes ony Data Warehouse Consumption.Read, which allows these users to preview only data output by views with the Expose for Consumption switch enabled. 

See Also

Standard Roles Delivered with SAP Datasphere

Keywords

KBA , DS-MD , Modeling (Data Builder) , DS-SEC , Security (Users, Roles) , Problem

Product

SAP Datasphere all versions