Skip to Content
0

CREATE REMOTE SUBSCRIPTION: Missing object priviliges

Sep 22, 2017 at 09:19 AM

403

avatar image
Former Member

Hi folks,

I'd like to use real time replication with SDI. I created a remote source with the ODBC Hana Adapter, trying to create a flowgraph and execute it. Basically this flowgraph uses a VIRTUAL TABLE (replicated from a HANA ERP system) and replicates to a TemplateTable (column table in HANA).

Unfortunately I'm not able to execute the flowgraph without the following error:

User _SYS_REPO is missing privileges: CREATE REMOTE SUBSCRIPTION for REMOTE SOURCE <REMOTE_NAME>".

I tried to give _SYS_REPO the missing object priviliges for my remote source. The problem is that the remote source has no schema ("none") and hence no owner. This means that even a sys user can't give _SYS_REPO the missing object priviliges.

Is it possible to create a schema for my remote source? Or any other possibilities to solve this problem?

Thanks in advance
Florian

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kishore Kumar reddy Oct 25, 2017 at 03:42 PM
0
Share
10 |10000 characters needed characters left characters exceeded