Skip to Content

Does my XSA installation have to be in the same tenant as my classic schema that I want to access?

I have XSA installed in it's own tenant called XSD. I want to access a schema via the "SAP Hana Service Connection". The "classic" schema I am trying to access is in a different tenant called DWD. Is this possible? Right now, when I attempt to build the .hdbgrants file, it gives me the error:

Error: Error executing: GRANT "SELECT","SELECT METADATA" ON SCHEMA...invalid user name:"

This is because it is looking for my application user in the DWD tenant where it is not found. That application user is created by the XSA build in XSD tenant.

Can I get around this without having to install XSA in the DWD tenant?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 11 at 03:24 AM

    Hi Dustin,

    You need to setup the connection using user provided service. Go through the tutorial below to see how to use user provided service for your case:

    https://developers.sap.com/tutorials/xsa-create-user-provided-anonymous-service.html

    **UPDATED 13-Jul-2020**

    Hi Dustin,

    It seems like below thread will answer your question:

    You can not use cross container access to cross over tenants.

    https://answers.sap.com/questions/13016302/tutorial-on-sap-hana-xs-advanced-need-help.html

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.