Permissions
This topic lists which permissions are required for Data Movement gateway to be able to capture changes with the SAP HANA (Database) connector.
- Grant SELECT and TRIGGER on the SAP schema containing the selected source tables, to the user specified in the connector settings.
- If the attrep_cdc_changes_cts table is created in a schema owned by the user specified in the connector settings (the default), no further permissions are required.
- If the attrep_cdc_changes_cts table is created in a schema not owned by the user specified in the connector settings, grant SELECT, INSERT, UPDATE and DELETE on the attrep_cdc_changes_cts table to the specified user.