add remote identity doesn't work with user system

[Former Member]

Hello everyone,

I get a strange problem while implementing cross tenant access on our hana environment. We get two hana base (P01, P02) and targets of P02 is P01. In this way we followed a lot of documentation as this link (https://blogs.sap.com/2014/12/19/step-by-step-tutorial-cross-database-queries-in-sap-hana-sps09/).

Our problem is when we want to add remote identity with user SYSTEM, we have followinf message "SAP DBTech JDBC: [258]: insufficient privilege: Not authorized"

May someone tell me how to add remote identity with user SYSTEM or if we miss something ?

Regards,

Laurent J.

[Former Member]

Solution was found.

[Former Member]

Would you mind to share how you solved the issue?

Thanks in advance.

[mario_bisonti2]

We had the same problem.

If you need to execute:
ALTER USER USER1 ADD REMOTE IDENTITY USER2 AT DATABASE ABC;

you need that USER2 exists on database ABC else you will obtain "SAP DBTech JDBC: [258]: insufficient privilege: Not authorized"

Mario