SAP Knowledge Base Article - Public

3469992 - Database user on Space-level is not able to consume tables and all schemas in SAP Datasphere


When using a Database user on Space-level, tables (remote and local) are not available for consumption.

In HANA Explorer, all the schemas are not listed comparing when using a Database User on Tentant-Level (Extended Capabillities).


 SAP Datasphere


This is working as design.

DB users on Space-level should only consume exposed views. While tables and non-exposed views will not be listed.
As well for schemas, only the OpenSQL schema, Space schema (if READ is enabled) and other a few technical spaces should appear when using a DB User on Space-level.

The only exception is when Space is defined as Monitoring Space. In this scenario, the DB User will have extended read capabilities for all schemas and tables. 
Only one space can be selected as Monitoring Space. Another monitoring space can be created, but the technical name must be SAP_ADMIN.

See Also


visibility, visible, could not find, search , KBA , DS-SM , Space Management , How To


SAP Datasphere all versions