Unable to call a HANA Table Function from Data Services

[Former Member]

Hi,

I have written a HANA table function to do some complex query and return a set of data. I then use the Table function in SQL transform (using SELECT query ) and send the fetched data it out to an external system.

When I execute the DS job and when it tries to run this Table Function, it says "insufficient privilege: Not authorized".

Inside the role of the DS user, this has been given to the Table function.

catalog sql object"<_SYS_BIC>"."<path_name>.procedures::<table_function_name>": EXECUTE;

I tried adding SELECT instead of EXECUTE , as table function is normally run through SELECT query only.

But it is giving a syntax error for SELECT and cannot activate it because of that.

Is there any way to solve this problem ?

I have tried it with Stored Procedure and it works fine, but it requires the data to be stored in an additional Table in HANA, which I want to avoid.

Regards,

Deepu.

[former_member198401]

Can you check the SAP Note 2286215 - SAP HANA DB: Cannot Create Procedure due to Error "insufficient privilege: Not authorized"...