Skip to Content
avatar image
Former Member

SAP Hana connectivity of DPA with remote source

Hello,

I am working on implementing SDI for SAP HANA. As I am trying to connect the Data provisioning agent to the remote source, I am provided with a script from SAP that I need to run on the source DB. The one concern I have is that the script is asking permissions for the user to Create new Tables and Alter Tables (althought this seems to be sys tables). What is the purpose of this request ? I would imagine this being a concern allowing an external entity to provide write access into the source DB.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    May 14 at 01:48 PM

    Hello Aniket,

    I am guessing that the source database is Oracle, you can see the necessity for each Oracle permission in our Install and Config documentation: https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS03/en-US/57cd2b8475b94567875bdd78b978a0c4.html


    SDI needs to create some tables in Oracle to store its runtime data. Alter table is only used temporarily, to enable table level supplemental logging when CDC replication begins.


    Thanks,
    Jeff K

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jeff,

      Is there any way to modify this script and proceed with the SDI without allowing Alter Table permissions ?

  • avatar image
    Former Member
    May 15 at 03:34 PM

    Thank you Jeff.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17 at 05:32 PM

    Hi Jeff,

    Is there any way to modify this script and proceed with the SDI without allowing Alter Table permissions ?

    Add comment
    10|10000 characters needed characters exceeded

  • May 22 at 07:57 PM

    Hi Aniket, regarding modifying the script.

    You can enable alter any table for the user temporarily, activate the subscriptions, then revoke the permissions. We only need it when the source tables are initially marked to be replicated. However, this is annoying to change the permissions whenever you need to add a new table for replication.

    The only other way to get around it is by enabling database level supplemental logging: https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS03/en-US/02a680d48e6f472ba4c395666bd2d753.html


    Best regards,

    Jeff K

    Add comment
    10|10000 characters needed characters exceeded