Skip to Content

[HANA SDI]privilege error when activating replication task

Apr 10, 2017 at 02:04 AM


avatar image
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

sdi-20170410.png (5.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Timo Wagner
Apr 10, 2017 at 11:33 PM

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 )

Kind Regards,

Timo Wagner

10 |10000 characters needed characters left characters exceeded