Getting Insufficient Privilege error SAP WEB IDE flowgraph while doing Smart Data Integration

[former_member255525]

Hi,

We are working on the SAP HANA Smart Data Integration using HanaAdapter wrt that. We have created a Flowgraph.

where we have added the Datasource to be a Virtual table and we are using Projection and Union nodes for the Data transformation purposes as shown in the screenshot below

It works perfectly fine. When I run this flowgraph giving me the DataTarget table as expected.

But If I change my Data Source settings to Realtime as shown in the below screenshot

The build is successful, and When I try to execute the flowgraph again. I am getting the following error

1:56:53 PM (/sample_sdi_for_cockpit/poc2_db) Execution Failed : (dberror) [686]: start task error: "POC2_HDI_POC2_UPDATED_DB_1"."POC2.poc2_db::UserSettingsTarget_SP": line 5 col 0 (at pos 107): [140038] Error executing SQL command in task.;Error executing ALTER_REMOTE_SUBSCRIPTION_QUEUE with command: 'ALTER REMOTE SUBSCRIPTION "POC2.poc2_db::UserSettingsTarget_RS" QUEUE'. ,exception 71000256: QUEUE: POC2.poc2_db::UserSettingsTarget_RS: Failed to add subscription for remote subscription POC2.poc2_db::UserSettingsTarget_RS[id = 164649] in remote source SSC_HANA_SRC[id = 159914]. Error: exception 151050: CDC add subscription failed: Failed to add the first subscription. Error: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [258] (at 17): insufficient privilege: only internal SYS user can modify objects in SYS and _SYS_AUDIT schema: line 1 col 18 (at pos 17)

I even tried adding the ALTER REMOTE SUBSCRIPTION privilege as part of my hdbgrants file

Here is my hdbgrants file

{
  "POC_ACCESS": {
    "object_owner" : {
      "global_object_privileges":[ 
        { 
          "name": "SSC_HANA_SRC",
          "type": "REMOTE SOURCE",
          "privileges" : [ "CREATE VIRTUAL TABLE", "DROP", "CREATE REMOTE SUBSCRIPTION","PROCESS REMOTE SUBSCRIPTION EXCEPTION","ALTER REMOTE SUBSCRIPTION" ]
        }         
      ]
    },
    "application_user" : {
      "global_object_privileges":[ 
        { 
          "name": "SSC_HANA_SRC",
          "type": "REMOTE SOURCE",          
          "privileges" : [ "CREATE VIRTUAL TABLE", "DROP", "CREATE REMOTE SUBSCRIPTION","PROCESS REMOTE SUBSCRIPTION EXCEPTION","ALTER REMOTE SUBSCRIPTION"]
        }         
      ]
    }
  }
}

When I build this file it throws error stating

Invalid Privilege ALTER REMOTE SUBSCRIPTION

I tried googling a lot and went through lot of blogs but I am unable to find anything

Kindly help me