Can we encrypt stored procedures in Hana？

[Former Member]

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

[lbreddemann]

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.

[former_member664588]

Hello,

I am trying to investigate in this matter, but it seems that either I have a different version installed or there is a problem. I am trying to use the WITH ENCRYPTION in a procedure/function but when I try it, it gives me this message

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "ENCRYPTION": line 4 col 21 (at pos 98)

Even when I try to use the CREATE OR REPLACE, it gives me this message

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "OR": line 1 col 8 (at pos 8) Could not execute 'END' SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "END": line 1 col 1 (at pos 1)

Do I have to setup something or this is something that should had work?

Thank you in advance for your help

Alejandro Raitarsky

[Trinidad]

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/20d467407519101484f190f545...

Hope it helps!
Trinidad.