SAP Knowledge Base Article - Public

3449689 - Database user receives insufficient privilege error in SAP HANA Database Explorer

Symptom

The SAP HANA Cloud database of SAP Datasphere tenant can be accessed via Database users which have been created in SAP Datasphere tenant.
Further information in SAP Help Portal Documentation: Create a Database User.

In case the database user is trying to execute a SELECT statement on a table in SAP HANA Database Explorer, the following error message is received:

Could not execute 'SELECT * FROM "<spaceID>"."<tableID>"'
Error: (dberror) [258]: insufficient privilege: Detailed info for this error can be found with guid 'xxxxxxxxxxxx' 

Environment

SAP Datasphere

Reproducing the Issue

  1. Create a space scoped database user - more information in SAP Help Portal Documentation: Create a Database User.
  2. Open SAP HANA Database Explorer
  3. Execute the SELECT statement

Cause

Space Schema Read Access can only enable the database users to read data from views that are created in the space with which they are associated if the view has the Expose for Consumption property enabled (see Exposing a View For Consumption).

Resolution

Create a Datasphere View based on the problematic table and switch on the "Exposed for Consumption"
More information in SAP Help Portal Documentation: Integrating Data via Database Users/Open SQL Schemas

Keywords

KBA , DS-SM , Space Management , DS-SEC , Security (Users, Roles) , How To

Product

SAP Datasphere all versions