In-DB "Datastream Out" not work on Server but in local Designer

Question

Hi allI have an In-DB workflow which runs perfect on my DesignerBut when I run it from the Gallery on our Server I get following error message:Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;258 insufficient privilege: search table error: insufficient privilege: Not authorized (please check lines: 17) (Tool Id: 30)Tool ID 30 is a Datastream Out tool.All other In-DB tools before are running perfect, only this tool makes problems.The Server runs on version 2020.2 and the designer on 2020.1.5.Do you have there any ideas ?Many thanksSteffen

hroderick-thr · Answer

For quick proof of security problem, run the workflow on server as the service account using designer instead of gallery. For me it is easier to see details of the error and pass them on to dba as a security change request.

rkapoor · Answer

@chvizda this is probably to do with the permissions that the user associated to your Server has on that table.  Can you check this?

Alternatively try to set the workflow up on Server to Run As a different user ie. the one that's used in Designer:

https://community.alteryx.com/t5/Alteryx-Server/Run-As-Settings/ta-p/17830