Error when inserting/Deleting records to table via Procedure in HANA Studio

[former_member462348]

Hi

Am facing Authorization issue when Deleting or Inserting records to a table in HANA Studio through Procedure.

But the same does not happen when doing it Via SQL console.

Can some one support.

Thanks

[pfefferf]

As you see in the error message, _SYS_REPO has missing privileges for that what you wanna do in the procedure. In the SQL console, you are using a separate user which has the privileges. I guess you have created your procedure with definer rights (in the procedure header). If that is what you wanna do, than _SYS_REPO needs the missing privileges.

[thomas_jung]

Your procedure is setup for definer rights therefore it executes as the user who created it - _SYS_REPO. So either you need to grant the necessary access to _SYS_REPO or change the procedure to invoked rights.