How to create and authorize users in HDI Containers ?

[marcus_schiffer]

Hi,

I use a HDI container on HANA Cloud from a Cloud Foundry app in python to perform machine learning operations. The results are stored in the corresponding HDI container schema.

I want to access the schema from a SAP Analytics Cloud via live model access.

This works fine for a connection to HANA using the users from the service keys from the HDI container.

Now the requirement is to assign SAC users certain rights depending on the dimensions. Since this seems to be impossible on the SAC, we would need to create users with these rights in the HANA HDI container. How can I create and maintain such users from the CF environment ? 

Any help is highly appreciated.

Regards

Marcus 

[gregorw]

Please check out the documentation Live Data Connection to SAP HANA Cloud Using an "SAP HANA Cloud" Connection. Especially the linked Assign Roles to Database Users.

[Vitaliy-R]

@marcus_schiffer, have you built Calculation Views on top of data in the HDI container? Structured filters and analytic privileges let you grant different users access to different portions of data within the same calc view.

[marcus_schiffer]

That would mean we need to create the users in HANA first via the user management. Is there a way to create these users and authorizations from WITHIN the Cloud foundry deployment process ? I found no "HANA Database Artifact" for Users......