call database procedure authorizations

[Former Member]

Hello,

we are trying to call HANA STP from ABAP program with "call database procedure". We created a proxy as described in the following document:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f06342ec-60a0-3010-b8aa-9ece92ae0...

but when we try to execute the ABAP report we get ashort dump: DBPROC_SQL_ERROR insufficient privilages.

Which privilages do we need to use the proxy?

Thanks,

Amir

[Former Member · Accepted solution]

As quite often, a search at http://service.sap.com/notes should help.
For example keyword DBPROC_SQL_ERROR will direct you to
SAP note 1989884 - DBPROC_SQL_ERROR / Error 258 while executing database procedure

regards

[Former Member · Accepted solution]

Hi Josef,

Thanks, I already implemented this note but still getting the dump.

Thanks,

Amir

[Former Member]

And does user SAP<SID> have 'EXECUTE' privileges on the HANA procedure you created?

[Former Member]

Yes,

It has privileges to execute the HANA procedure