How can I activate a HANA object programatically?

[Former Member]

We have a need to re-activate an object programatically in HANA. Is there a way to do this in HANA SPS12 or greater?

There is a bug in HANA where sometimes changes to objects require re-generation / re-activation of a HANA security repository & runtime role since the role loses the object that was changed. In these cases, we have to involve a security specialist to re-activate/re-generate the role. We want to provide self-service ability to developers so they don't have to involve a security person to re-generate the role, can this be done programatically? Or is there another option to do this without giving the developers direct access to Activate the role in hana studio?

Or is there another fix / work-around to resolve this HANA bug?

[former_member610293]

I wonder if something like this can be used to auto regenerate hana roles (HDBROLE) . We have a an issue where a change to the underlying object means we have to manually regenerate the role. Any advice?

[thirus11]

Hi David,

Kindly go through the below link for more info

SAP HANA REST API Reference

Check on File AP1->Technical Aspects->Activation Mode

Best Regards,

Thiru

[Former Member]

Thank you Thomas, do you have that API name and what package it is contained under?

[thomas_jung]

There is the Repository REST API that will perform activation, but this API would require the same security that performing the activation via HANA Studio or Web-workbench would require.