Default access role for debugging Node js XSA application

[sergey_korolev]

Hello,

Trying to debug Node.js application for HANA XSA. Among other things I need to create global temporary tables (or just physical tables). I managed to allow this to the default technical user by defining default_access_role.hdbrole file. And this works fine if I just deploy application into XSA and run a corresponding request.

However, it does not work if I run the same app from Web IDE for HANA in debug mode - it always gives "insufficient privilege: Not authorized" message.

Why? How to grant sufficient rights to the debug user?

[sergey_korolev]

Anything more valuable?

I followed the debug procedure described in SAP-PRESS book "SAP HANA XSA. Native development for SAP HANA" (p 510). No HTML5 module, no Router configuration. Could anyone clarify why in debug mode (via Web IDE for HANA) app returns insufficient privilege error and works fine after deploying to XSA?

[thomas_jung]

There isn't a separate debug user. Is it perhaps that you are testing the application via the node.js module directly and not passing through the App Router (and therefore not getting your user security token injected in the Node.js module)?

[sergey_korolev]

Yes, perhaps. I created a Run configuration with my package json start script, which actually just calls node with server.js.

And your answer implies that when I just deploy application into XSA and run it, it always runs via App Router, doesn't it? But I have only Node js app and HANA DB Module, and there no sign of App Router in my configuration. Why this is works then?