SQL Script has insufficient authorization

[Former Member]

1. We have a stored procedure in HANA DB server (HND).
2. We have to call this stored procedure in  an AMDP class-method created in our app server HNA.
3. We plan to consume or invoke this method in  Netweaver Gateway  to create an O-data service that will be given to SAP UI5 client for consumption.

We face some issues while implementing this scenario.

• We have created a stored procedure PRC_CREATE_PLANHDRDTL in catalog of our user schema SAPCAR. This schema lies in our HANA database server HND, into which we have logged in using uid : SAPCAR
• Next we have created a AMDP Class in our HNA ABAP Application Server, using ABAP perspective of HANA studio by logging in using a different id and trying to call this procedure from the AMDP method.

• During the syntax check we are getting the following issue

SQL Script has insufficient authorization

How do we resolve this error?

We have our stored procedure in HND server which we have logged in using SAPCAR id , and the ABAP class is in HNA server which we have logged in using a different id.

Also note that HND is the db server of HNA.

Thanks.

[manjunath_b]

Hello,

In the HANA studio, logon to your HANA system HND. To the user SAPCAR, add the object privilege 'execute' on schema SAPCAR and the procedure object. This should resolve the issue.

Thanks and regards,

Manjunath