Skip to Content
avatar image
Former Member

How can I activate a HANA object programatically?

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 26, 2017 at 06:17 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 26, 2017 at 08:07 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2017 at 11:02 AM

    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

    Add comment
    10|10000 characters needed characters exceeded