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

1 Answer

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