Skip to Content
-1

add remote identity doesn't work with user system

Jul 27, 2017 at 02:55 PM

131

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jul 31, 2017 at 07:37 AM
0

Solution was found.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Would you mind to share how you solved the issue?

Thanks in advance.

0

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

0