HANA procedure from BW: authorization issues

[former_member285493]

Hello everyone,

I've setup a few store procedure to be used from BW but I'm getting an authorization error when executing the proxy SP:

SQL error 258 in call of DB procedure XXXXXX: insufficient privilege: current user has no privilege on XXXXXXX.

User _SYS_REPO is authorized on the custom schema, and of course I can run the SP from HANA.

What could be missing?

Thanks

[FCI]

The Hana user used by BW (generally SAPSR3) should be authorized on this sp.

Regards,

Frederic