Skip to Content

HDBSynonyms , HDB Grants and authorization issues

Hello ,

I have created a new HDI Container and created a synonym on top of existing HDI Container(not the one I created). When I am building the project , I am getting an error , saying "The container object owner is not authorized to access Synonym target. User needs to be provided select privileges on Target Object.

i am not sure how to provide grant option.Can someone Please help me. I am working on Cloud Foundry SAP Cloud Platform

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 20, 2020 at 03:29 PM

    Hi Thomas Jung , Ivan Mirisola

    I figured out the issue. Let me say as a work around.

    I have created synonyms using the synonym editor , I have selected the tables. Wizard itself populated the code like schema name , db name etc etc.

    As I am trying to use the same table in different application with synonyms , actual table's schema is not changed through out the development system. So Deployment of second application never failed in Development.
    But When I deploy the first application to Quality , in Quality , I observed new schema number . So When I am trying to deploy the second application (which contains the synonyms of first application), it is giving errors as I have used Dev schema in the synonym wizard.

    Now , in the schema wizard, I have selected the quality schema of tables and deployed second application to Quality. It got deployed successfully

    But i would like to understand how to do it correctly without changing schemas in synonmys every single i wanted to transport.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2020 at 05:59 PM

    Thank you very much Thomas Jung

    Granter

    SynonmConfig

    Synonym

    Is everything correct? When I put my cursor on DB Module and click on build , I see an error message ,

    "Failed to retrieve service type: granter-db"

    and I can't deploy the application now.

    Following are the screen shots of YAML File

    Sorry for too many questions... Thanks again for all that you are doing :)


    granter.png (11.8 kB)
    config.png (18.1 kB)
    synonym.png (15.0 kB)
    yaml-1.png (10.6 kB)
    yaml-2.png (12.2 kB)
    yaml-3.png (8.8 kB)
    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.