How to Access HDI Containers (SAP HANA)
Maybe you have already tried to access HDI containers with SYSTEM oder DBADMIN users and have failed.
Or maybe you were only able to access HDI containers with the HDI container runtime user (RT-User, some call it the technical user).
This the following articles and videos describe how to create a new user and enable it to access data inside a HDI container.
General Principle
The SYSTEM or DBADMIN User has no access to HDI container tables.
For that is needed in the following order:
- HDI Administrator
- HDI Container Group Administrator
- HDI Container Administrator (can be the same user as the group administrator)
But the SYSTEM or DBADMIN User cannot directly grant this access as neither of them does have it itself.
There are a couple of stored procedures in the HANA db which enable to create the users listed above.
The following reference and video show how to proceed:
Reference
SAP HANA Platform - SAP HANA Deployment Infrastructure (HDI) Reference
SAP HANA Cloud - SAP HANA Cloud Deployment Infrastructure (HDI) Reference
Video
ABAP Freak Show Ep. 17 - SAP HANA Deployment Infrastructure (HDI) Administration
