Skip to Content

SAP HANA XSA Web IDE: HDI Container - CURRENT_USER

Hi,

we want to trigger our application. If we use CURRENT_USER than I get the technical user. Is there a way to get the application or client user?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 06, 2017 at 02:25 PM

    Have you tried this? SELECT SESSION_CONTEXT('APPLICATIONUSER') "APPLICATION_USER" FROM "DUMMY";

    Add comment
    10|10000 characters needed characters exceeded

    • SESSION_CONTEXT('APPLICATIONUSER') works like a charm. :)

      But still only one point of this trigger statement annoys me. Setting each column separately would be very time consuming. I looked also for a solution where I can only work with tables. May be one of you has an idea.

      But at this moment I'm glad that it works so far.

      Thanks!