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
- Create a space scoped database user - more information in SAP Help Portal Documentation: Create a Database User.
- Open SAP HANA Database Explorer
- 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