cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos
677

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

Accepted Solutions (0)

Answers (1)

Answers (1)

CharlesFeng
Advisor
Advisor
0 Kudos

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