[HANA SDI]privilege error when activating replication task

[Former Member]

Dear all

I have encountered an authorization error when setting SDI replication task.

I logged in web-based workbench as system user.

I created a new replication task (*.hdbreptask).

When I activate the task, an error occurred.

I attached screen shot.

Please kindly help me to resolve the issue.

Best regards, Yusuke Sugihara

[former_member240828]

Hello Yusuke,

for the activation of any Repository objects it will use the internal Repo User _SYS_REPO.

In this case this user is missing some privileges that you need to grant to _SYS_REPO first.
For Reptasks this should be the CREATE VIRTUAL TABLE on top of the Remote Source as well as some permissions on the target schema (see https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS00/en-US/b37ba74df07145b9bcc52be... )

Kind Regards,

Timo Wagner