I have a scenario where calculation views built in XS classic need to source data from tables in an HDI container.
In order to do this, _SYS_REPO must have SELECT privileges on the objects WITH GRANT OPTION.
The issue I am encountering is:
What is the proper mechanism to grant _SYS_REPO privileges on objects in an HDI container with grant option, so that these object can be used in XS classic calculation views?
The check that '#' roles can only be assigned to #OO is done in the HDI API GRANT_CONTAINER_SCHEMA_ROLES.
Instead, use a classical GRANT statement with a user having ROLE ADMIN privilege. This way, you will be able to assign '#' roles to any user like _SYS_REPO.
In addition, if your classical calculation view is a graphical one, you will have to create a synonym on top of your hdi calculation view in _SYS_BIC schema. This is required by the calculation graphical editor in HANA Studio. For this, use an .hdbsysbicsynonym artifact (see https://help.sap.com/viewer/3823b0f33420468ba5f1cf7f59bd6bd9/2.0.04/en-US/0bf88516d12b40ee9605b9f75fae568e.html )
Add a comment