3714956 - Database user receives an "invalid table name" error in SAP HANA Database Explorer

Access to SAP HANA Cloud of SAP Datasphere by database users at the space level. For more information about database users at the space level: User Management.

When the database user executes a SELECT statement on a view which has been exposed and shared from another space, the following error message occurs:

Could not execute 'Select * from "<spaceID>"."<viewID>"' Error: (dberror) [259]: invalid table name: Could not find table/view <viewID> in schema <spaceID>: line *** col *** (at pos ***) 

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

SAP Datasphere

1. Deploy a view which has been enabled "Expose for Consumption" in space A.
   
2. Share the exposed view from space A to space B.
3. Create a database user with full privileges in space B.
4. Open SAP HANA Database Explorer by the created database user.
5. Execute the SELECT statement for the shared view.

After views are shared from space A to space B, they are accessible in space B only at the tenant level, not at the database level, due to product design.

There is an enhancement request for this point: https://influence.sap.com/sap/ino/#/idea/320530/?section=sectionDetails.

The alternative way is to create and expose a new view in Space B based on the shared view so it can be accessed at the database level. 

https://community.sap.com/t5/technology-q-a/datasphere-shared-view-is-not-available-in-database/qaq-p/13661085

views not visible, views not accessible, remote source, space management, database analysis user , KBA , DS-SM , Space Management , DS-MD-VIW , Views , Problem