Missing privilege - DELETE statement in procedure

[Former Member]

Hello experts,

I am facing a problem for my procedure. I am not able to active the procedure if I use DELETE statement in the produce. When I use only selects, it is working fine. The SYSTEM user has access to the schema with full rights, including DELETE.

PROCEDURE "SYSTEM"."DEV_COL.procedures::FI" ( )

  LANGUAGE SQLSCRIPT

  SQL SECURITY INVOKER

  DEFAULT SCHEMA UXX790

  AS

BEGIN

/*****************************

  Write your procedure logic

*****************************/

-- SELECT vbeln

--count(*)

  DELETE

  from vbapold

  where erdat < ADD_days(now(), -1700);

END;

Did anybody had the same issue? I run HANA rev70.

BR
Tamas

[lbreddemann · Accepted solution]

Hi Tamas

if this is a repository procedure user _SYS_REPO has to have the DELETE privilege with grant option as well.

- Lars

[Former Member · Accepted solution]

Thanks Lars,

that was the missing one.

BR
Tamas