HANA SDA Remote Source - Authorization

[#1]

I have created a remote source XYZ in HANA DB. Only I can alter this remote source. I have tried to grant authorization to a role so that I can assign this role to others.

GRANT ALTER ON REMOTE SOURCE "XYZ" TO ROLE "REMOTE_SOURCE_ALTER" WITH GRANT OPTION;
I get a syntax error      "near "XYZ"."

Help!

[Chris1973]

Hi @Martin2 

Thank you for your question.

The syntax error you're getting is likely due to either:

• Incorrect use of quotes or case in the remote source name.
• Use of WITH GRANT OPTION without sufficient privileges.
• Not being the owner of the remote source.

I suggest you try this version:

GRANT ALTER ON REMOTE SOURCE XYZ TO ROLE "REMOTE_SOURCE_ALTER";

Please make sure you're executing it as the user who created the remote source or has the necessary admin rights.

I hope this helps provide clarity for your customer. I am happy to help if you have further questions.

If you find my response helpful, kindly accept the answer and award a Kudos to this post. Your support is appreciated.

Best regards

Chris

[Martin2]

I have just found out that the error goes away when I delete the word ROLE