How to Access HDI Containers (SAP HANA): Unterschied zwischen den Versionen
Matt (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „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 wit…“) |
Matt (Diskussion | Beiträge) Keine Bearbeitungszusammenfassung |
||
| Zeile 1: | Zeile 1: | ||
Maybe you have already tried to access HDI containers with SYSTEM oder DBADMIN users and have failed. | 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 HDI containers with the HDI container runtime user (RT-User, some call it the technical user) | 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 == | == General Principle == | ||
| Zeile 9: | Zeile 7: | ||
The SYSTEM or DBADMIN User has no access to HDI container tables. | The SYSTEM or DBADMIN User has no access to HDI container tables. | ||
For that is needed in the following order: | 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: | |||
# HDI Administrator | # HDI Administrator | ||
| Zeile 15: | Zeile 15: | ||
# HDI Container Administrator (can be the same user as the group administrator) | # 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 == | == Reference == | ||
| Zeile 30: | Zeile 34: | ||
https://help.sap.com/viewer/c2cc2e43458d4abda6788049c58143dc/2020_04_QRC/en-US/b4b6a8936bc64526b8fd8491c4a40eaa.html | https://help.sap.com/viewer/c2cc2e43458d4abda6788049c58143dc/2020_04_QRC/en-US/b4b6a8936bc64526b8fd8491c4a40eaa.html | ||
[[Category:SAP]] | [[Category:SAP]] | ||
[[Category:HANA]] | [[Category:HANA]] | ||
Aktuelle Version vom 5. März 2021, 19:21 Uhr
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:
- HDI Administrator
- HDI Container Group Administrator
- 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
SAP HANA Cloud - SAP HANA Cloud Deployment Infrastructure (HDI) Reference
