How to change Access Mode of HANA Stored procedure

[Former Member]

Hi,

When you are creating a stored procedure as design time object, one of the option is access mode (either read only or read/write).

I understand read only is default setting in HANA DB, and unless you explicitly change the setting you cannot read/write using stored procedure.

My question is, is there way to change this setting, so I have option to choose either read or read/write when I create a stored proc?

Thank you.

Hyun

[rindia · Accepted solution]

Hi Hyun,

To change the setting, please follow below steps as shown in the exhibit:

  

Double click and change the value to UNSECURE.

Regards

Raj

[former_member182302]

Hi Hyun,

Please have a look on this thread:

You have to enable sqlscript_mode to UNSECURE as mentioned by lars.

Then depending on whether you are specifiying "READS SQL DATA" it will act as a READ procedure else as a WRITE procedure.

Regards,

Krishna Tangudu