How to make stored procedure as read only which having create, insert, delete and update function.

[former_member773582]

Dear All,

I want to make attached stored procedure to be read only for creation calculation view in the HANA studio.

This stored procedure have create, insert, update and delete statement that's why not able to convert into read only.

Please suggest solution for this.

Thanks.

Sandeep Undencm-r1-new-cube.txt

[CharlesFeng]

Hi Sandeep,

Could you please check if "READS SQL DATA" meet your request?

READS SQL DATA
Specifies that the procedure is read only and side-effect free. That is, the procedure does not make modifications to the database data or its structure, even if the procedure body contains dynamic SQL calls.

The advantage of using this parameter is that certain optimizations are available for read-only procedures.

[Reference]
https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.05/en-US/20d467407519101484f190f545...

Best regards,
Charles