SAPDB -- What are the required permissions working with SAP DB Endpoint?

[Sonja_Bauernfeind]

Tech-note - FAQ

QUESTION

What are the required permissions working with SAP Application DB Endpoint?

ANSWER

The SAPDB Endpoint requires database access to the following tables:

• DD02L
• DD03L
• DD02T
• DD03T
• T000

Depending on the transports you also need to grant permissions to the following tables:

• /HTG/GC_HEAD
• /HTG/GC_TABLES1

The newer version of the Transports require these instead:

• /HTG/GC4R_BUSGRP
• /HTG/GC4R_TABLES

Example command in Oracle: 

GRANT SELECT ON SAPSR3./HTG/GC4R_BUSGRP TO attunity_user

The command will vary depending on the backend. Contact your SAP administrator for details.