Skip to Content
0
Sep 15, 2020 at 12:53 PM

Unable to access function in hdblibrary using anonymous block

54 Views

Hi All,

I have some issues with a small library - it contains one table function getVariables and it is defined using the hdblibrary artefact. It deployed just fine and I can execute it from HANA Studio where the necessary rights is assigned (execute on library) - like this :

do begin using "HDI_DB_1"."session" as lib1;
  select * from lib1:"getVariables"(null);
end;

However when trying to execute it from webIDE(removed the HDI schema prefix in the using part) using the dataexplorer (SQL Console/SQL Console(Admin) I am not able to do so - and I receive a DBerror #258

Could not execute 'do begin using "session" as lib1;   select * from lib1:"getVariables"(null); end'
Error: (dberror) [258]: insufficient privilege: Detailed info for this error can be found with guid '....' 

I looked up the guid and have the following,

SESSION_USER_NAME_____________ : HDI_DB_1....DT
CHECKED_USER_NAME_____________ : HDI_DB_1....DT
PRIVILEGE_____________________ : EXECUTE
IS_MISSING_ANALYTIC_PRIVILEGE_ : FALSE
IS_MISSING_GRANT_OPTION_______ : FALSE
DATABASE______________________ :
SCHEMA_NAME___________________ : HDI_DB_1
OBJECT_NAME___________________ : session
OBJECT_TYPE___________________ : LIBRARY

So it looks to me that the HDI user doesn't have access to execute the object? Any suggestions on what could be the issue (Running this on an HXE, SPS 04)

/MiB