How to give access to Database Explorer users to calculation view in Cloud Foundry

[alixpel]

Tutorials: https://developers.sap.com/tutorials/hana-cloud-calculation-view-differential-privacy.html
--------------------------

Hello 🙂

I created a calculation view in Cloud Foundry, with data from an HANA database. It was successfully deployed (see screenshot).

I see it in Database Explorer (see screenshot).

But My colleague, who has access to the database this view extracts from, doesn't. Ultimately, I would like to use this view in SAC.

What did I miss ?

[Willem_Pardaens · Accepted solution]

The HDI deployer created a runtime user to access the Calculation View inside your HDI container. You are using this runtime user via the 'SharedDevKey' which is nothing more than a Key for the Service Instance you see in your BTP cockpit. You can grant access to your HDI by granting the access_role of your HDI to your colleague:

GRANT "YourHDISchemaName::access_role" TO YourColleague;

[alixpel · Accepted solution]

Thank you for your help Willem.

With your input, I could do some research and find several options here A live data connection to SAP HANA Cloud in SAP Analytics Cloud | SAP Blogs.

If someone faces the same issue, let me know 🙂