SAP Knowledge Base Article - Public

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

Symptom

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

Environment

 SAP Datasphere

Resolution

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.

NOTE
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

Keywords

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

Product

SAP Datasphere all versions