insufficient privilege: search table error: Authorization failed in Calculation Engine.

[param0308]

Hi ,

We have created a source system (ODP - SAP HANA Information Views) in quality BW system(7.5 on HANA).

And when we execute the infopackage to read the data from HANA view as a source through the ODP source system, it always throws error:

insufficient privilege: search table error: [2950] exception 306003: Authorization failed in Calculation Engine. User is not authorized to 'SELECT'

• We are aware that what privileges to be assigned and we are able to run in dev system.
• We also tried to trace the user authorization but no log generated.

Here is the Flow:

1:Created RFC HANA_XYZ

2:Maintained user, which also has corresponding DB user (with the same user view can be executed in the HANA studio)

3:Maintained the source system

4:Tested the connection

5: After TR transport all the Data sources replicated successfully.

6: When execute the infopackage, it throws error.

am I missing any configuration?

Regards

[yoona_kim]

Hi.

I am also facing the same issue.

Could you share how to solve it?

Thank you.