> How to find user session in Firebird, similar to in Oracle like

v$session?

>

Hi B,

I imagine you are after one of the following context variables.

CURRENT_USER
CURRENT_CONNECTION
CURRENT_TRANSACTION
CURRENT_ROLE

Inside a stored procedure or trigger you can reference these variables
directly.

eg:

if (CURRENT_USER = 'SYSDBA') then ....

If you are wanting to return the information to a client application

select CURRENT_USER
from RDB$DATABASE;

Hope that helps
Adam