CREATE REMOTE SUBSCRIPTION: Missing object priviliges

[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

[former_member398172]

I found the documentation to not be very clear. After some struggle, this statement worked for me:

GRANT CREATE REMOTE SUBSCRIPTION on REMOTE SOURCE "your_remote_source" to _SYS_REPO;

[former_member500539]

I had the same issue earlier. below link will be helpful

https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS00/en-US/b37ba74df07145b9bcc52be...