Home / Q&A / How to get the current user id in Denodo that is logged in?
You can translate the question and the replies:

How to get the current user id in Denodo that is logged in?

How to get the username from the current session in Denodo? This username is Denodo user and NOT any of the underlying data sources' login. The close query I found is running the below: select * from get_sessions() which gives all the sessions that are logged in. Thanks, Sundaram
userid
user
12-05-2022 18:48:21 -0400

1 Answer

Hello, You can achieve this using the GETSESSION() function. You can find out more on this function and how to use it on [Denodo Community Page - Other Functions](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/other_functions/other_functions#getsession). An example of how it should be used goes as follows: ``` select getsession('user') from dual(); ``` Hope this helps!
Denodo Team
23-05-2022 04:38:19 -0400
You must sign in to add an answer. If you do not have an account, you can register here