Skip to Content
0
Jul 12, 2018 at 01:50 PM

HANA Procedure authorisations

436 Views Last edit Jul 12, 2018 at 02:29 PM 3 rev

Hi all,

I have created procedure/table function under schema SYSREPO and fetching data from table present in schema SAPABAP1. The same will be called in graphical calculation view.

I am getting authorisation error on that select query while debugging.

SYSREPO has complete object privileges for SAPBAP1.

I have tried below statements but getting authorisation error.

GRANTSELECTONSCHEMA"SAPABAP1"TO"_SYS_REPO"WITHGRANTOPTION;

GRANTSELECTONSCHEMA"_SYS_REPO"TO"SAPABAP1"WITHGRANTOPTION;

Sever Trace file shows the same.

I have gone through thread

https://archive.sap.com/discussions/thread/3483015. Please let me know which privileges needs to be assigned to user?