HANA cross Schema Access - Error

[former_member743230]

Hi All,

Scenario:

I have a schema A which has virtual tables in it. Now I wanted to use them inside HDI container and I followed your tutorials to create the synonyms, User provided service and a role that needs to used in grantor file and an User who has this role and access to schema A.

In user provided service json I have"

{
    "password": "user_pass",
    "schema": "A",
    "tags": [
        "hana"
    ],
    "user": "user"
}

tags: hana, because the schema A in the same DB as HDI.

now this is working perfectly fine in dev-space

I tried to deploy my application in QA-space where for the user provided service I used the same json as above, but I am getting below error:
OUT Processing "cfg/test.hdbgrants"...

OUT Using grantor service "test_CONNECTION" of type "sql"

ERR Error: authentication failed

ERR grantor service: "test_CONNECTION", type: "sql", user: "user"

ERR file name: cfg/SAP_ECC_CLIENT.hdbgrants

Thanks in advance!