Skip to Content
0

[HANA SDI]privilege error when activating replication task

Apr 10, 2017 at 02:04 AM

508

avatar image

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
0

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/b37ba74df07145b9bcc52bedcb8c900d.html )

Kind Regards,

Timo Wagner

Share
10 |10000 characters needed characters left characters exceeded