Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Insufficient privilege .hdbprocedure file

Hi,

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" ( )

  LANGUAGE SQLSCRIPT

  SQL SECURITY INVOKER

  --DEFAULT SCHEMA <default_schema_name>

  --READS SQL DATA AS

  as

BEGIN

update "BEST"."store_transaction"

set "Amount" = "Amount"+("Amount")*0.1

where "Particulars" = 'TV';

END;

Same update statement when I am trying to run in SQL console, it is successful.

Br

Sumeet

Tags:
replied

Done.

GRANT INSERT ON SCHEMA <schema> TO _SYS_REPO WITH GRANT OPTION.


Br

Sumeet

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question