Hi Adam,

What if I want to get all user sessions in record fashion like in
v$session?

As example, using user sessions info, I can list of all applications
which specific using particular 'module' -- that is the application
connects to Firebird.

TIA,

Cheers,
B. Adji Maharyatno

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
> > 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