Skip to Content
-1

Can we encrypt stored procedures in Hana?

Oct 20, 2016 at 06:11 AM

155

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Lars Breddemann
Nov 24, 2017 at 12:29 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Maria Trinidad MARTINEZ GEA
Nov 22, 2017 at 02:33 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded