How to Access HDI Containers (SAP HANA)

Maybe you have already tried to access tables in HDI containers with SYSTEM oder DBADMIN users and have failed.

Or maybe you were only able to access tables in HDI containers with the HDI container runtime user (RT-User, some call it the technical user).

General Principle

The SYSTEM or DBADMIN User has no access to HDI container tables.

Neither of these users can directly grant this access to HDI container tables to other users as neither of them has it itself.

For that is needed to create the following users in the following order:

  1. HDI Administrator
  2. HDI Container Group Administrator
  3. HDI Container Administrator (can be the same user as the group administrator)

There are a couple of stored procedures in the HANA db which enable you to create the users listed above.

This the following hands on video and reference articles describe how to create the new user listed above and enable it to access data inside a HDI container.

Video

ABAP Freak Show Ep. 17 - SAP HANA Deployment Infrastructure (HDI) Administration

https://www.youtube.com/watch?v=zyHhxZWW40M&t=851s

Reference

SAP HANA Platform - SAP HANA Deployment Infrastructure (HDI) Reference

https://help.sap.com/viewer/3823b0f33420468ba5f1cf7f59bd6bd9/2.0.04/en-US/b4b6a8936bc64526b8fd8491c4a40eaa.html

SAP HANA Cloud - SAP HANA Cloud Deployment Infrastructure (HDI) Reference

https://help.sap.com/viewer/c2cc2e43458d4abda6788049c58143dc/2020_04_QRC/en-US/b4b6a8936bc64526b8fd8491c4a40eaa.html