Hana XSA grants with .hdbrole file issue

[NDG]

Hi,
when I try to build .hdbrole file in XSA it returns the follow message:

Processing grants files...
Processing "src/grants.hdbgrants"...
Using grantor service "hana_connection" of type "sql"
Error: Error executing: GRANT "ROLE_R#" TO "PORTALEDQM_HDI_DB_MODULE_DQM_1#OO";
(nested message: invalid role name: ROLE_R#: line 1 col 7 (at pos 6))
grantor service: "hana_connection", type: "sql", user: "XXX"
file name: src/grants.hdbgrants

But if I try to add the same role to the same user directly in HANA I don't have any issue.

Below the screen of .hdbrole file:

and .hdbgrants file

Many thanks in advance.

Nicola

[thomas_jung]

How did you define your grantor service, hana_connection? Could it possibly be pointing to a different tenant (via the sql port definition) than your target HDI container? That's usually the case when you receive this error.

[NDG]

Hi Thomas
thanks for the reply, I confirm that the port entered in my grantor service is correct, it points to the correct tenant.

I can't understand what it could depend on.

Thanks

Nicola