Insufficient privilege .hdbprocedure file
I am scheduling stored procedure using .xsjob but when I am trying to create .hdbprocedure file and giving below code , its says ' could not create catalog object Insufficient privilege'.
code in .hdbprocedure
PROCEDURE "BEST"."sumeet10::update_store_master" ( )
SQL SECURITY INVOKER
--DEFAULT SCHEMA <default_schema_name>
--READS SQL DATA AS
set "Amount" = "Amount"+("Amount")*0.1
where "Particulars" = 'TV';
Same update statement when I am trying to run in SQL console, it is successful.