[Solved] Find session_user in HSQL2.5

[gkick]

Hi all,

In a multi user setup I can find out who is registered as a system user by running SELECT * FROM INFORMATION_SCHEMA.SYSTEM_USERS, but I am at a complete loss as to how to find the name of the CURRENT_USER or SESSION_USER which apparently is the same? The HSQL manual only waffles about some temporary table ? There must be a way to list all sessions and associated users.
Anyone familiar with this, thanks for your thoughts.

[Sliderule]

There must be a way to list all sessions and associated users.

Code: Select all

SELECT 
   INFORMATION_SCHEMA.SYSTEM_SESSIONS.* 
FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS

and, choose the columns you wish to see / use.

For example:

Code: Select all

SELECT 
   INFORMATION_SCHEMA.SYSTEM_SESSIONS.SESSION_ID, 
   INFORMATION_SCHEMA.SYSTEM_SESSIONS.USER_NAME,
   INFORMATION_SCHEMA.SYSTEM_SESSIONS.CONNECTED 
FROM INFORMATION_SCHEMA.SYSTEM_SESSIONS

SYSTEM_SESSIONS

Information on all open sessions in the database (when used by a DBA user), or just the current session. Includes the current transaction state of each session.

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.

[gkick]

Thanks, works like a treat!