Skip to Content
0
Jan 27 at 09:16 AM

Access XSC Hana calculation view via synonym MTA project from XSA

179 Views Last edit Feb 15 at 02:01 PM 6 rev

Hi,


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

From <https://help.sap.com/viewer/4505d0bdaf4948449b7f7379d24d0f0d/2.0.02/en-US/556452cac83f423597d3a38a6f225e4b.html>

Issue details:

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) [258]: insufficient privilege: search table error:[2950] 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
"VBELN",
"VBELP",
"ZDEMAND",
"Row_count"

FROM "BWSAPECCMASTERDATA_HDI_BWSAPECCMASTERDATA_DB_1"."BwSapEccMasterData.models::ZCV_BHPOP_PO_DM";

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;

Synonym

We did try both hdbgrants and hdbsynonymgrantor with roles as shown

hdbgrants code

Regards,

Kevin Dass

Attachments

xsa-2.png (98.1 kB)
xsa-3.png (67.8 kB)
xsa-3.png (67.8 kB)
xsa-4.png (106.7 kB)
xsa-5.png (111.2 kB)
xsa-2.png (85.9 kB)
xsa-3.png (61.1 kB)