Skip to Content
avatar image
Former Member

CREATE REMOTE SUBSCRIPTION: Missing object priviliges

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 25, 2017 at 03:42 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 06, 2018 at 10:21 PM

    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;

    Add comment
    10|10000 characters needed characters exceeded