Use a Datasphere View in a SAP CAP service over an HDI container - View not exposed for consumption

[Cristian]

Hello experts,

I am trying to interact with a Datasphere View from a SAP CAP service. I am following the mission as follows:

https://github.com/SAP-samples/datasphere-build-apps-data-entry

The issue is when I am trying to deploy the SAP CAP service (https://github.com/SAP-samples/datasphere-build-apps-data-entry/tree/main/documentation/develop/depl... as I am getting the error as follows:

error: "SAC$TEC"."HDI_GRANTOR_FOR_CUPS": line 43 col 9 (at pos 2079): Unsupported Feature: Cannot grant the requested privilege, because SAC.ZGV_SO_ICOMMNETS is not exposed for consumption)

This is at high level what we have:

A view created in Datasphere which is exposed for consumption.

A technical user with privileges to read and write.

A in BTP a User Provided Service named "datasphere-sac-space-ups" with the details of the above user:

{
    "password": "XXXXXXXXX",
    "procedure": "HDI_GRANTOR_FOR_CUPS",
    "procedure_schema": "SAC$TEC",
    "schema": "SAC",
    "tags": [
        "hana"
    ],
    "type": "procedure",
    "user": "SAC#SAC_POC"
}

.hdbgrants as follows:

{
	"datasphere-sac-space-ups": {
		"object_owner": {
			"roles": [],
			"container_roles": [],
			"object_privileges": [
                {
				  "type": "VIEW",
				  "name": "ZGV_SO_ICOMMNETS",
				  "privileges_with_grant_option": [
				    "SELECT","READ","WRITE"
				  ]
				}
			]
		}
	}
}

.hdsynonym

{
  "SAP_POC": {
    "target": {
        "schema": "SAC",        
        "object": "ZGV_SO_ICOMMNETS"
    }
  }
}

But unfortunately, we are getting the error already mentioned when deploying the CAP application.

error: "SAC$TEC"."HDI_GRANTOR_FOR_CUPS": line 43 col 9 (at pos 2079): Unsupported Feature: Cannot grant the requested privilege, because SAC.ZGV_SO_ICOMMNETS is not exposed for consumption)

Any ideas about what may be happening?

Thanks in advance!

C.

[MarcoKj]

Hi! Did you manage to solve the issue?