We have been having issues even after following SAP notes and SAP Help Doc(details below) with accessing XSC hana calculation view via synonym MTA project on XSA in Web IDE.
2459265 - How to access foreign schemas in SAP Web IDE for SAP HANA (XS Advanced)
2916898 - How to create synonym for non-HDI schema table in XSA
Database Synonyms in XS Advanced
Accessing XSC calculation view from _SYS_BIC system schema via synonym MTA project in Web IDE. Note table access from other schema like (HANABW) works fine
Could not open 'BWSAPECCMASTERDATA_HDI_BWSAPECCMASTERDATA_DB_1'.'BwSapEccMasterData.models::ZCV_BHPOP_PO_DM'.
Error: (dberror) : insufficient privilege: search table error: exception 306003: Authorization failed in Calculation Engine. User is not authorized to 'SELECT'
The data preview uses the following statement fetch data:
SELECT TOP 1000
XSC HANA Calculation View:
Note this view has “Apply Privileges” set to BLANK as well.
UPS user and respective roles
UPS user BH_UPS_SYSBIC has been created with below grants SET SCHEMA _SYS_BIC; -- Create role to be granted for external access via synonym CREATE ROLE "BH_UPS_SYSBIC::EXTERNAL_ACCESS"; --grant select on schema _SYS_BIC to "BH_UPS_SYSBIC::external_access"; -- use this for allow access to the whole schema GRANT SELECT ON "_SYS_BIC"."<full_namespace>/ZCV_BHPOP_PO_DM" TO "BH_UPS_SYSBIC::EXTERNAL_ACCESS"; CREATE ROLE "BH_UPS_SYSBIC::EXTERNAL_ACCESS_G"; --grant select on schema _SYS_BIC to "BH_UPS_SYSBIC::external_access_g" with grant option; -- use this for allow access to the whole schema GRANT SELECT ON "_SYS_BIC"."<full_namespace>/ZCV_BHPOP_PO_DM" TO "BH_UPS_SYSBIC::EXTERNAL_ACCESS_G" WITH GRANT OPTION;
We did try both hdbgrants and hdbsynonymgrantor with roles as shown