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

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' 

SAP Datasphere

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

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).

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

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