Skip to Content
avatar image
-1
Former Member

add remote identity doesn't work with user system

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Solution was found.

    Add comment
    10|10000 characters needed characters exceeded

    • 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