Skip to Content
avatar image
-1
Former Member

Can we encrypt stored procedures in Hana?

Hi Expert

I heard that in HANA SPS12 stored procedures can be encrypted in some way, but I can't find any document/link on this topic.

Does anyone has the link or material ?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 24, 2017 at 12:29 AM

    This feature is available as of HANA 2 SP02 (https://blogs.sap.com/2017/07/27/sap-hana-2.0-sps-02-new-developer-features-database-development/).

    Be careful with using it though, as it requires the encryption during activation on the target system. That means you cannot deliver DUs to clients and have them install a closed source procedure. Instead, the resulting catalog object is encrypted.

    Also, encrypted procedures/functions cannot be debugged - which usually is a bad thing for production environments.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2017 at 02:33 PM

    The openSAP training "Software Development on SAP HANA (Update Q4/2017)" is talking about it in the Unit 4: SQLScript, slide 13:

    https://open.sap.com/courses/hana6/items/7qzHDS1xe45xnOdat1y82D

    Also documented here:

    https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/20d467407519101484f190f545d54b24.html

    Hope it helps!
    Trinidad.

    Add comment
    10|10000 characters needed characters exceeded