Skip to Content
0
Former Member
Sep 23, 2014 at 09:23 AM

Missing privilege - DELETE statement in procedure

26 Views

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